ASP.NET

Michael†Cheong wrote:

Cannot insert the value NULL into column 'ItemCode', table '...Product'; column does not allow nulls. INSERT fails.

protected void Save_Click1(object sender, EventArgs e)
       {
           //Response.Redirect("~/2Staff/EditProduct.aspx?txtID=" + txtID.Text);

           string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
           SqlConnection conn = new SqlConnection(connStr);
           string strInsert;
           SqlCommand cmdins;

           // if (txtbox3.Trim().Length == 0)

           if (DropDownList1.SelectedValue.Equals("Default"))   //Discount
           {
               String txtbox3 = TextBox3.Text;
               double t = Convert.ToDouble(txtbox3);
               Dis = Math.Round(t, 2);
               Label5.Text = Dis.ToString();
           }

           conn.Open();
           strInsert = "INSERT INTO Product (ItemCode,ItemName,ItemCategory,ItemDesc,ItemPrice) VALUES(@code,@name,@ctgy,@desc,@price)";
           cmdins = new SqlCommand(strInsert, conn);

           cmdins.Parameters.AddWithValue("@code", txtID.Text);
           cmdins.Parameters.AddWithValue("@name", TextBox2.Text);
           cmdins.Parameters.AddWithValue("@ctgy", RadioButtonList1.SelectedValue.ToString());
           cmdins.Parameters.AddWithValue("@desc", Editor1.Content);
           cmdins.Parameters.AddWithValue("@price", Dis);
           cmdins.ExecuteNonQuery();

           conn.Close();

           //-----------------------------------------------------------------------------image--------------------------------------
           HttpPostedFile myPostedFile1 = FileUpload1.PostedFile;
           HttpPostedFile myPostedFile2 = FileUpload2.PostedFile;
           HttpPostedFile myPostedFile3 = FileUpload3.PostedFile;
           HttpPostedFile myPostedFile4 = FileUpload4.PostedFile;
           HttpPostedFile myPostedFile5 = FileUpload5.PostedFile;



           if (myPostedFile1 != null && myPostedFile1.ContentLength > 0)
           {
               FileInfo finfo = new FileInfo(myPostedFile1.FileName);
               string fileExtension = finfo.Extension.ToLower();
               if (fileExtension != ".gif" && fileExtension != ".jpg" && fileExtension != ".jpeg" && fileExtension != ".png")
               {
                   Label3.Text = "error";
                   // MessageBox.SetMessage("WARNING: Please select a picture, with file format gif, jpg, jpeg and png!", Message.MessageType.Warning);
               }

               else if (FileUpload1.HasFile)
               {


                   byte[] productImage = FileUpload1.FileBytes;

                   // SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                   string connnStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                   SqlConnection conn1 = new SqlConnection(connnStr);
                   string query = " INSERT INTO Product (ItemImg) VALUES (@img1)";

                   SqlCommand com = new SqlCommand(query, conn1);
                   com.Parameters.Add("@img1", SqlDbType.VarBinary).Value = productImage;

                  // com.Parameters.AddWithValue("@img1", productImage);
                   conn1.Open();
                   com.ExecuteNonQuery();
                   conn1.Close();

                   //getting length of uploaded file



               }

           }

           //--------------------------------------------Auto Generate ID---------------------------------------------------

           string strSelect;
           SqlCommand cmd;
           SqlDataReader myReader;

           conn.Open();
           strSelect = "Select ItemCode From Product";
           cmd = new SqlCommand(strSelect, conn);
           myReader = cmd.ExecuteReader();

           while (myReader.Read())
           {
               String Strings = myReader["ItemCode"].ToString();

               String intString = Strings.Substring(3, 5);
               txtID.Text = "" + intString;
               columnValue = int.Parse(intString);
               newValue = columnValue + 1;
               txtID.Text = "PIC" + newValue.ToString();

           }

           myReader.Close();
           conn.Close();

           //--------------------------------------------Close Auto Generate ID---------------------------------------------------

       }

byte[] productImage = FileUpload1.FileBytes;
string query = "UPDATE Product SET ItemImg = @img1 WHERE ItemCode = @code";

using (SqlConnection conn1 = new SqlConnection(connStr))
using (SqlCommand com = new SqlCommand(query, conn1))
{
    com.Parameters.AddWithValue("@code", txtID.Text);
    com.Parameters.Add("@img1", SqlDbType.VarBinary).Value = productImage;
    
    conn1.Open();
    com.ExecuteNonQuery();
}

public static string BuildImageDataUri(byte[] imageBytes, string mimeType)
{
    return "data:" + mimeType + ";base64," + Convert.ToBase64String(imageBytes);
}

Kalim_mughal wrote:

I am showing around 100,000 record

Kalim_mughal wrote:

I am showing around 100,000 record

Kalim_mughal wrote:

I don't want to apply paging in data control

vasanth2vasu wrote:

My main aim is to reduce the CPU work usage.

Quote:

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string strddl;
SqlCommand cmdddl;

Quote:

try
{
conn.Open();
strddl = "INSERT INTO Users (Username,Name,UserID,Password,UserRoles,SecurityAns) VALUES(@user,@name,@id,@pass,@roles,@Sec)";
cmdddl = new SqlCommand(strddl, conn);

cmdddl.Parameters.AddWithValue("@user", TextBox1.Text);
cmdddl.Parameters.AddWithValue("@name", TextBox2.Text);
cmdddl.Parameters.AddWithValue("@id", CID);
cmdddl.Parameters.AddWithValue("@pass", Password.Text);
cmdddl.Parameters.AddWithValue("@roles", Role);
cmdddl.Parameters.AddWithValue("@Sec", TextBox6.Text);
cmdddl.ExecuteNonQuery();


conn.Close();

}
catch (Exception ex)
{
Response.Redirect("~/ErrorPage.aspx");
}