.NET (Core and Framework)

Dim cmd As New SqlCommand
       cmd.Connection = mcon
       cmd.CommandText = "insert into members(serial, name, familyname, address, phone, mobile, fax, email, website, space, timezone) values (@serial, @name, @familyname, @address, @phone, @mobile, @fax, @email, @website, @space, @timezone) ;"
       cmd.Parameters.AddWithValue("@serial", txtserial.Text)
       cmd.Parameters.AddWithValue("@name", txtname.Text)
       cmd.Parameters.AddWithValue("@familyname", txtfamilyname.Text)
       cmd.Parameters.AddWithValue("@address", txtaddress.Text)
       cmd.Parameters.AddWithValue("@phone", txtphone.Text)
       cmd.Parameters.AddWithValue("@mobile", txtmobile.Text)
       cmd.Parameters.AddWithValue("@fax", txtfax.Text)
       cmd.Parameters.AddWithValue("@email", txtemail.Text)
       cmd.Parameters.AddWithValue("@website", txtwebsite.Text)
       cmd.Parameters.AddWithValue("@space", txtspace.Text)
       cmd.Parameters.AddWithValue("@timezone", cmbtimezone.Text)
       cmd.ExecuteNonQuery()
       fillgrid()

Member 10506215 wrote:

How am i going to set the identity to txtserial.text?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

if (System.IO.File.Exists(serpath))
{

    System.Drawing.Image myimage1 = System.Drawing.Image.FromFile(serpath);

    int thumb_width = 400, thumb_height = 100;
    using (System.Drawing.Bitmap thumb_bitmap = new System.Drawing.Bitmap(thumb_width, thumb_height))
    {
        using (System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(thumb_bitmap))
        {
            g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
            g.Clear(Color.White);
            g.DrawImage(myimage1, 0, 0, thumb_width, thumb_height);
        }
        myimage1.Dispose();
        System.Drawing.Imaging.ImageCodecInfo jpeg = default(System.Drawing.Imaging.ImageCodecInfo);
        jpeg = System.Drawing.Imaging.ImageCodecInfo.GetImageEncoders().
               Where((System.Drawing.Imaging.ImageCodecInfo enc) => 
                   enc.FormatID == System.Drawing.Imaging.ImageFormat.Jpeg.Guid)
                   .FirstOrDefault();


        System.Drawing.Imaging.EncoderParameters Params = new System.Drawing.Imaging.EncoderParameters(1);
        Params.Param[0] = new System.Drawing.Imaging.EncoderParameter(System.Drawing.Imaging.Encoder.Quality, 100L);

        thumb_bitmap.Save(serpath, jpeg, Params);

    }
    
}
else
{
    signatureImage.Save(serpath, System.Drawing.Imaging.ImageFormat.Jpeg);
}
}