Connection String 

SqlConnection con =new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);


        List<string> lst = new List<string>();
     


private void BindListBox()
        {
            DataTable dt = new DataTable();

            if (con.State != ConnectionState.Open)
                con.Open();
            using (SqlCommand cmd = new SqlCommand(@"Select Rid,Name from Tbl_Regi", con))
            {
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);

                //listbox1.DataSource = dt;
                //listbox1.DataBind();

                foreach (DataRow item in dt.Rows)
                {
                    lst.Add(item["Name"].ToString());
                }
                listbox.Items.Clear();
                listbox.DataSource = lst;
                listbox.DataBind();
            }
            if (con.State != ConnectionState.Closed)
                con.Close();
        }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            //StringCollection sc = new StringCollection();
            List<string> lst = new List<string>();
            foreach (ListItem item in listbox1.Items)
            {
                if (item.Selected)
                {
                    lst.Add(item.Text);
                }
            }
            InsertRecords(lst);
        }
        private void InsertRecords(List<string> lst)
        {
            string qry = string.Empty;
            try
            {
                StringBuilder sb = new StringBuilder();
             
                foreach (string item in lst)
                {
                     qry = @"Insert Into Tbl_Test values";
                    sb.AppendFormat("{0}('{1}')", qry,item);
                }
                using (SqlCommand cmd = new SqlCommand(qry,con))
                {
                    cmd.CommandText = sb.ToString();
                    if (con.State != ConnectionState.Open)
                        con.Open();
                    cmd.ExecuteNonQuery();
                }
                Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);
            }
            catch (Exception ex)
            {

            }
            finally
            {
                if (con.State != ConnectionState.Closed)
                    con.Close();
            }
        }

Comments

Post a Comment

Popular posts from this blog

String Program in C#

using System; using System.Linq; 1)Reverse Name String  in C# String Name="Sudam"; int Len=Name.Length-1; while(Len>=0) { Console.Write(Name[Len]); Len--; } ----------------------------------------- Output --madus ----------------------------------------- 2)Reverse Words of a String in C# string s = "I Name Is Sudam"; string[] a = s.Split(' '); int temp= a.Length - 1; while (temp >= 0) {     Console.Write(a[temp] + ' ');     temp--; } ------------------------------------------ Output --Sudam Is Name I ---------------------------------------- 3) How to Fine count how many double letters are in a string? int doubleLetters = 0; string characters = "Hello"; for (int i = 0; i < characters.Length - 1; i++) {     if (characters[i] == characters[i + 1])     {         doubleLetters++;         i++;     }     Console.WriteLine(doubleLetters); } -----------------------------------------...
Read more

CSV using XmlNode

 To create a CSV from an XmlNode in C#, you can follow these steps: 1. Parse the XML structure using XmlNode. 2. Extract the data you need from child nodes. 3. Write the CSV content using a StringBuilder or directly with StreamWriter. Here's a sample code snippet: using System; using System.IO; using System.Text; using System.Xml; public class XmlToCsvConverter {     public static void ConvertXmlNodeToCsv(XmlNode rootNode, string csvFilePath)     {         StringBuilder csvContent = new StringBuilder();         // Assuming all child nodes have the same structure         // Add header         if (rootNode.HasChildNodes)         {             XmlNode firstRow = rootNode.FirstChild;             for (int i = 0; i < firstRow.ChildNodes.Count; i++)             {     ...
Read more

Extension Method & Partial Class

  Extension - extension method allows you to add new methods in the existing class or in the structure without modifying the source code of the original type and you do not require any kind of special permission from the original type and there is no need to re-compile the original type. Partial Class- It provides a special ability to implement the functionality of a single class into multiple files and all these files are combined into a single class file when the application is compiled. A partial class is created by using a partial keyword. First(): it returns the first element from a sequence means when we query in a collection on specific criteria, if multiple elements are found in a collection of given criteria then the first element of a sequence will return. -First it can't handle the null value. var emp = Employee.GetAllEmp().Where(x => x.Name == "Ashutosh").First();   FirstOrDefault(): FirstOrDefault works same as First() does, FirstOrDefault returns the ...
Read more