ASP.NET

Quote:

Application 'MACHINE/WEBROOT/APPHOST/TestAppCore20' with physical root 'E:\TestAppCore20\' failed to start process with commandline '%LAUNCHER_PATH% .\TestAppCore20.dll', ErrorCode = '0x80070002' : 0.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <location path="." inheritInChildApplications="false">
    <system.webServer>
      <handlers>
        <add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModule" resourceType="Unspecified" />
      </handlers>
      <aspNetCore requestTimeout="02:00:00"
		processPath="%LAUNCHER_PATH%" 
		arguments=".\TestAppCore20.dll" 
		stdoutLogEnabled="true" 
		stdoutLogFile=".\logs\stdout"
		forwardWindowsAuthToken="false"
 />
    </system.webServer>
  </location>
</configuration>
<!--ProjectGuid: 97cf335d-efd6-4064-bca2-7a4901141162-->

sp:HyperLinkField DataNavigateUrlFields="filename" headertext="Recording" DataNavigateUrlFormatString="http://Archive/{servername from DB}/play_recording_wav.asp.net?filename='noop_'{0}'.wav" Text="Listen" />

http://archives/server1/play_recording_wav.aspx?filename=noop_Grants.wav

c = "archives/"+ '<%# Eval("Servername") %> + "noop_" + Eval("filename") %>' + ".wav"

Cannot insert the value NULL into column 'Status_Id', table 'ITInventory.dbo.Workstations'; column does not allow nulls. INSERT fails.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;


namespace InventoryStock
{
    public partial class Workstations : Form
    {
        public object WExpiry_Date { get; private set; }

        public Workstations()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void label1_Click_1(object sender, EventArgs e)
        {

        }

        private void Workstations_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'iTInventoryDataSet.Workstations' table. You can move, or remove it, as needed.
            this.workstationsTableAdapter.Fill(this.iTInventoryDataSet.Workstations);
            comboBox3.SelectedIndex = 0;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            
            SqlConnection con = new SqlConnection(@"Data Source=sh-jasonk\dev;Initial Catalog=ITInventory;Integrated Security=True");
            //Insert Logic
            con.Open();
            bool Wkst_Status = false;
            if (comboBox3.SelectedIndex == 0)
            {
                Wkst_Status = true;
            }
            else
            {
                Wkst_Status = false;
            }

            SqlCommand cmd = new SqlCommand
        
            (@"INSERT INTO [dbo].[Workstations]
           (
           [Emp_Name]
           ,[Emp_Surname]
           ,[Department]
           ,[Company]
           ,[Hostname]
           ,[Wkst_Status]
           ,[Make]
           ,[Model]
           ,[SerialNumber]
           ,[ProductNumber]
           ,[Purch_Date]
           ,[WExpiry_Date]
           ,[Memory]
           ,[Processor]
           ,[HDD]
           ,[OS])
          
     VALUES
           ('" + txtName.Text + "','" + txtSurname.Text + "','" + comboBox1.Text + "','" + comboBox2.Text + "','" + txtHostName.Text + "','" + comboBox3.SelectedIndex + "','" + txtMake.Text + "','" + txtModel.Text + "','" + txtSN.Text + "','" + txtPN.Text + "','" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "','" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "','" + txtMem.Text + "','" + txtProc.Text + "','" + txtHDD.Text + "','" + txtOS.Text + "')",con);

         
            //Conversion failed here
            cmd.ExecuteNonQuery();
            con.Close();
       
            //Reading Data
            SqlDataAdapter sda = new SqlDataAdapter(@"Select  [Emp_Name][Emp_Surname],[Department],[Company],[Hostname],[Wkst_Status],[Make],[Model]
                                                             ,[SerialNumber],[ProductNumber],[Purch_Date],[WExpiry_Date],[Memory],[Processor],[HDD]
                                                             ,[OS] From [dbo].[Workstations]", con);
            
            DataTable dt = new DataTable();
            sda.Fill(dt);
            dataGridView1.Rows.Clear();

            foreach (DataRow item in dt.Rows)
            {
                int n = dataGridView1.Rows.Add();
                dataGridView1.Rows[n].Cells[0].Value = item["Emp_Name"].ToString();
                dataGridView1.Rows[n].Cells[1].Value = item["Emp_Surname"].ToString();
                dataGridView1.Rows[n].Cells[2].Value = item["Department"].ToString();
                dataGridView1.Rows[n].Cells[3].Value = item["Company"].ToString();
                dataGridView1.Rows[n].Cells[4].Value = item["Hostname"].ToString();
                if ((bool)item["Wkst_Status"])
                {
                    dataGridView1.Rows[n].Cells[5].Value = "Active";
                }
                else
                {
                    dataGridView1.Rows[n].Cells[5].Value = "Inactive";
                }

              
                dataGridView1.Rows[n].Cells[6].Value = item["Make"].ToString();
                dataGridView1.Rows[n].Cells[7].Value = item["Model"].ToString();
                dataGridView1.Rows[n].Cells[8].Value = item["SerialNumber"].ToString();
                dataGridView1.Rows[n].Cells[9].Value = item["ProductNumber"].ToString();
                dataGridView1.Rows[n].Cells[10].Value = item["Purch_Date"].ToString();
                dataGridView1.Rows[n].Cells[11].Value = item["WExpiry_Date"].ToString();
                dataGridView1.Rows[n].Cells[12].Value = item["Memory"].ToString();
                dataGridView1.Rows[n].Cells[13].Value = item["Processor"].ToString();
                dataGridView1.Rows[n].Cells[14].Value = item["HDD"].ToString();
                dataGridView1.Rows[n].Cells[15].Value = item["OS"].ToString();
            }

        }
    
        private void label17_Click(object sender, EventArgs e)
        {

        }
    }
}

USE [ITInventory]
GO

/****** Object:  Table [dbo].[Workstations]    Script Date: 2019/05/20 19:18:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Workstations](
	[Emp_Id] [int] IDENTITY(1,1) NOT NULL,
	[Emp_Name] [varchar](30) NOT NULL,
	[Emp_Surname] [varchar](30) NOT NULL,
	[Department] [varchar](50) NOT NULL,
	[Company] [varchar](30) NOT NULL,
	[Hostname] [nvarchar](20) NOT NULL,
	[Wkst_Status] [varchar](15) NOT NULL,
	[Make] [varchar](12) NOT NULL,
	[Model] [varchar](15) NOT NULL,
	[SerialNumber] [nvarchar](30) NOT NULL,
	[ProductNumber] [nvarchar](30) NOT NULL,
	[Purch_Date] [date] NOT NULL,
	[WExpiry_Date] [date] NOT NULL,
	[Memory] [nvarchar](6) NOT NULL,
	[Processor] [nvarchar](10) NOT NULL,
	[HDD] [nvarchar](10) NOT NULL,
	[OS] [nvarchar](25) NOT NULL,
	[Status_Id] [int] NOT NULL,
 CONSTRAINT [PK__Workstat__262359ABF6F5A9AA] PRIMARY KEY CLUSTERED 
(
	[Emp_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Workstations]  WITH CHECK ADD  CONSTRAINT [FK__Workstati__Statu__6FE99F9F] FOREIGN KEY([Status_Id])
REFERENCES [dbo].[Status] ([Status_Id])
GO

ALTER TABLE [dbo].[Workstations] CHECK CONSTRAINT [FK__Workstati__Statu__6FE99F9F]
GO

Hello 

I'm using the Ajax ToolKit File Upload 

I upload very well the files of Word, Excel, txt, jpg, PNG, XML, zip....

But AutoCAD files type dwg, IPT, stp ….. the Ajax ToolKit File Upload CAN NOT upload …. only mark ERROR when you click the UPLOAD button.


The size of AutoCAD files is small from 150kb  to 300kb 

Because these types of DWG files cannot be loaded ????



This is my HTML Codigi and this is the Web. Config


<pre>

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="ajaxToolkit" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="styles.css" rel="stylesheet" type="text/css" media="screen"/>
</head>

<body>
        <form id="form1" runat="server">
        <asp:scriptmanager runat="server"></asp:scriptmanager>       
    <div>
                    <ajaxToolkit:AjaxFileUpload 
                        ID="AjaxFileUpload1"
                        runat="server" 
                        OnUploadComplete="AjaxFileUpload1_UploadComplete" 
                        OnUploadCompleteAll="AjaxFileUpload1_UploadCompleteAll" 
                        Mode="Auto" 
                        ChunkSize="4096" 
                        MaxFileSize="21000000" />
    </div>        
    </form>
</body>
</html>

<?xml version="1.0" encoding="UTF-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <customErrors mode="Off" />
    <compilation debug="true" targetFramework="4.5">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      </assemblies>
    </compilation>
    <httpRuntime maxRequestLength="20480" targetFramework="4.5" />
    <httpHandlers>
      <add verb="*" 
           path="AjaxFileUploadHandler.axd"
           type="AjaxControlToolkit.AjaxFileUploadHandler, AjaxControlToolkit, Version=4.5.7.725, Culture=neutral, PublicKeyToken=28F01B0E84B6D53E"
           />
    </httpHandlers>
  </system.web>
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <handlers>
      <add name="AjaxFileUploadHandler" 
           verb="*"
           path="AjaxFileUploadHandler.axd"
           type="AjaxControlToolkit.AjaxFileUploadHandler,AjaxControlToolkit"/>
    </handlers>
    <defaultDocument>
      <files>
                <clear />
                <add value="Default.aspx" />
                <add value="LoginP.aspx" />
                <add value="LoginA.aspx" />
      </files>
    </defaultDocument>
  </system.webServer>
</configuration>