ASP.NET

tronix01 wrote:

i know localization

System.Drawing.ColorConverter colConvert = new ColorConverter();
lblSample.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("Your Color");

kalyansantosh wrote:

i developed a Windows apllication (Payroll)

kalyansantosh wrote:

After closing the closing the application the data is not saving

kalyansantosh wrote:

con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
cmd = new SqlCommand("insert into TDept values('" + TXT_TDName.Text + "')", con);
//cmd.CommandText = q;
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.AddWithValue("@TDName", TXT_TDName.Text);
con.Open();
int r = (int)cmd.ExecuteNonQuery();
Quote Selected Text

cmd = new SqlCommand("insert into TDept values('" + TXT_TDName.Text + "')", con);

private void button1_Click(object sender, EventArgs e)
       {
           saveFileDialog1.FileOk += new CancelEventHandler(saveFileDialog1_FileOk);
           saveFileDialog1.ShowDialog(this);

       }

       void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
       {
           SaveFileDialog ss = sender as SaveFileDialog;

           SqlDataAdapter da = null;
           try
           {
               con = new SqlConnection();
               con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
               da = new SqlDataAdapter("select * from card_details", con);
               DataSet ds = new DataSet(); da.Fill(ds, "card_details");
               ds.WriteXml(ss.FileName);
           }
           catch (SqlException ex)
           {
               throw new System.Exception("Error -- " + ex.Message);
           }
           catch (Exception exp)
           {
               throw new System.Exception("Error -- " + exp.Message);
           }
           finally
           {
               con.Close(); da.Dispose();
           }

       }