Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Using SqlCommand , how to add multiple parameters to its object , insertion via winform in sql table
- INSERT INTO item (c1,c2,c3...,c10) values (@a,@b....@j)
- cmd.Parameters.Add("@a",SqlDbType.Varchar)
- cmd.Parameteres["@a"].Value=textbox1.Text;
- cmd.Parameters.Add("@b",SqlDbType.Varchar)
- cmd.Parameteres["@b"].Value=textbox2.Text;.
- .
- .
- .
- .
- cmd.Parameters.Add("@j",SqlDbType.Varchar)
- cmd.Parameteres["@j"].Value=textbox10.Text;
- INSERT INTO item (c1) values (@a)
- cmd.Parameters.Add("@a",SqlDbType.Varchar)
- cmd.Parameteres["@a"].Value=textbox1.Text;
- INSERT INTO item (c2) values (@b)
- cmd.Parameters.Add("@b",SqlDbType.Varchar)
- cmd.Parameteres["@b"].Value=textbox2.Text;.
- .
- .
- INSERT INTO item (c10) values (@j)
- cmd.Parameters.Add("@j",SqlDbType.Varchar)
- cmd.Parameteres["@j"].Value=textbox10.Text;
- public static class DbCommandExtensions
- {
- public static void AddInputParameters<T>(this IDbCommand cmd,
- T parameters) where T : class
- {
- foreach (var prop in parameters.GetType().GetProperties())
- {
- object val = prop.GetValue(parameters, null);
- var p = cmd.CreateParameter();
- p.ParameterName = prop.Name;
- p.Value = val ?? DBNull.Value;
- cmd.Parameters.Add(p);
- }
- }
- }
- cmd.AddInputParameters(new { a = textBox1.Text, b = TextBox2.Text, /* etc */ });
- cmd.Parameters.AddWithValue("@j",textbox10.Text);
- cmd.Parameters.AddWithValue("@k",textbox11.Text);
- cmd.Parameters.AddWithValue("@l",textbox12.Text);
- void AddParams(DBCommand cmd,params object[] parameters)
- {
- if (parameters != null)
- {
- int index = 0;
- while (index < parameters.Length)
- {
- cmd.Parameters.AddWithValue("@"+(string)parameters[index], parameters[index + 1]);
- index += 2;
- }
- }
- }
- AddParams(a,"test1",b,3,c,DateTime.Now);
Add Comment
Please, Sign In to add comment