quote:

---

Originally posted by X002548

ou want to Insert 4 rows of data to 1 table in 1 SQL step?

Is that what you're asking?

The answer is, perhaps...

Where is the data coming from?

If you're asking to insert data into 2 tables at the same time?

The answer in no



This means I have to write a function in VS:

var TestRecords = new[] {
new { UserID = UserID,
CardId = DropDownList4.Text+CreditCardNumber.Text,
Attribute = "Credit card type",
Value = DropDownList4.Text },
new { UserID = UserID,
CardId = DropDownList4.Text+CreditCardNumber.Text,
Attribute = "Credit card number",
Value = CreditCardNumberEncrypt + UserID },
new { UserID = UserID,
CardId = DropDownList4.Text+CreditCardNumber.Text,
Attribute = "Name on card",
Value = NameOnCardEncrypt },
new { UserID = UserID,
CardId = DropDownList4.Text+CreditCardNumber.Text,
Attribute = "Expiry Date",
Value = MM.Text +"/" + yearEnd }};
foreach (var item in TestRecords)
{
SqlDataSource1.InsertParameters["UserID"].DefaultValue = item.UserID;
SqlDataSource1.InsertParameters["CardId"].DefaultValue = item.CardId;
SqlDataSource1.InsertParameters["AttributeName"].DefaultValue = item.Attribute;
SqlDataSource1.InsertParameters["Value"].DefaultValue = item.Value;
SqlDataSource1.Insert();





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

---