Reply to thread

Message

<blockquote data-quote="Mathh" data-source="post: 162763" data-attributes="member: 46622">Hi all,Maybe You will find a solution - how to save (insert into statement) multiple textboxes in one column in SQL table?Well, what I have is a winform with 20 textboxes (each is for one metric). Table is build like:Team&nbsp;&nbsp; |&nbsp;&nbsp; GSDate&nbsp; &nbsp; |&nbsp; &nbsp; GSGroup&nbsp; &nbsp; |&nbsp; &nbsp; GSMetric&nbsp; &nbsp; |&nbsp; &nbsp;&nbsp; GSValue&nbsp; &nbsp; |&nbsp; &nbsp; LoggedBywhat I would like to achieve, using one buton event to save all my textboxes:[CODE]Team&nbsp;&nbsp; |&nbsp;&nbsp; GSDate&nbsp; &nbsp; |&nbsp; &nbsp; GSGroup&nbsp; &nbsp; |&nbsp; &nbsp; GSMetric&nbsp; &nbsp; |&nbsp; &nbsp;&nbsp; GSValue&nbsp; &nbsp; |&nbsp; &nbsp; LoggedBy&nbsp; FR&nbsp; &nbsp; &nbsp; 08/21/2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CRC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Calls&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 100%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; User1&nbsp; FR&nbsp; &nbsp; &nbsp; 08/21/2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CRC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Emails&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 98.7%&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; User1&nbsp; FR&nbsp; &nbsp; &nbsp; 08/21/2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CRC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Handled&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; User1[/CODE]it's a sample, but for GSMetric I would like to add all values from textboxes, and for GSValue as well, because those are changing in relation to remaining values (Team, GSDate, GSGroup, LoggedBy)I'm using parameters.AddWithValue.[CODE]&nbsp; &nbsp; &nbsp; &nbsp; Sql = &quot;INSERT INTO tbl_Metrics (Team, GSDate, GSGroup, GSMetric, GSValue, LoggedBy) VALUES (@Team, @date, @group, @metric, @value, @user)&quot;&nbsp; &nbsp; &nbsp; &nbsp; Using comm As New SqlCommand()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; With comm&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Connection = cn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .CommandType = CommandType.Text&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .CommandText = Sql&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Parameters.AddWithValue(&quot;@Team&quot;, gslog.cbGSTeam.SelectedItem)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Parameters.AddWithValue(&quot;@date&quot;, MetDate.SelectedDate)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Parameters.AddWithValue(&quot;@group&quot;, me3.Text)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Parameters.AddWithValue(&quot;@metric&quot;, meH3.Text)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Parameters.AddWithValue(&quot;@value&quot;, m1.Text.ToString)[/CODE]Thank you in advance!</blockquote>

[QUOTE="Mathh, post: 162763, member: 46622"] Hi all, Maybe You will find a solution - how to save (insert into statement) multiple textboxes in one column in SQL table? Well, what I have is a winform with 20 textboxes (each is for one metric). Table is build like: Team | GSDate | GSGroup | GSMetric | GSValue | LoggedBy what I would like to achieve, using one buton event to save all my textboxes: [CODE] Team | GSDate | GSGroup | GSMetric | GSValue | LoggedBy FR 08/21/2013 CRC Calls 100% User1 FR 08/21/2013 CRC Emails 98.7% User1 FR 08/21/2013 CRC Handled 12 User1 [/CODE] it's a sample, but for GSMetric I would like to add all values from textboxes, and for GSValue as well, because those are changing in relation to remaining values (Team, GSDate, GSGroup, LoggedBy) I'm using parameters.AddWithValue. [CODE] Sql = "INSERT INTO tbl_Metrics (Team, GSDate, GSGroup, GSMetric, GSValue, LoggedBy) VALUES (@Team, @date, @group, @metric, @value, @user)" Using comm As New SqlCommand() With comm .Connection = cn .CommandType = CommandType.Text .CommandText = Sql .Parameters.AddWithValue("@Team", gslog.cbGSTeam.SelectedItem) .Parameters.AddWithValue("@date", MetDate.SelectedDate) .Parameters.AddWithValue("@group", me3.Text) .Parameters.AddWithValue("@metric", meH3.Text) .Parameters.AddWithValue("@value", m1.Text.ToString) [/CODE] Thank you in advance! [/QUOTE]

Verification