Question

i am doing a project on web service and window form basically i meet some problem and not sure how to solve

i 想通过网络服务在数据网格的每行各取数据,并输入数据基,以获得像这一行文1;第2行;第3行;第4卷......索一只花了路,但用面面面面面面图显示,以黑体表示。

private void push_Click(object sender, EventArgs e)

{

    string nominal;

    for (int i = 0; i < DGV.Rows.Count; i++)
    {
        nominal = Convert.ToString(DGV.Rows[i].Cells[1].Value);

    }
    WSBrand insertInto = new WSBrand();
    insertInto.Insert(**nominal**)
}

这是我的插入方法。

[WebMethod]

public DataSet Insert(String BrandName)
{

    SqlCommand dbCommand = new SqlCommand();
    dbCommand.CommandText = "INSERT INTO Brand (BrandName)VALUES (@BrandName)";
    dbCommand.Connection = conn;
    da = new SqlDataAdapter();
    da.SelectCommand = dbCommand;
    dbCommand.Parameters.AddWithValue("@BrandName", BrandName);


    DataSet ds = new DataSet();
    da.Fill(ds);
    return ds;
}

Answer 1

private void push_Click(object sender, EventArgs e)
{    
    StringBuilder nominal = new StringBuilder();
    for(int i = 0;i<DGV.Rows.Count;i++){
        nominal.Append(Convert.ToString(DGV.Rows[i].Cells[1].Value) + ";");
    }
    WSBrand insertInto = new WSBrand();
    InsertInto.Insert(nominalList); 
}

在贵族学校:

    [WebMethod]
public DataSet Insert(string nominal)
{        
    SqlCommand dbCommand = new SqlCommand();
    dbCommand.CommandText = "INSERT INTO Brand (BrandName)VALUES (@BrandName)";
    dbCommand.Connection = conn;
    dbCommand.Parameters.AddWithValue("@BrandName", sb.ToString());
    dbCommand.ExecuteNonQuery();

    SqlCommand dbCommand2 = new SqlCommand();
    dbCommand2.CommandText = "SELECT * FROM Brand";
    dbCommand2.Connection = conn;
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = dbCommand2;
    dbCommand2.ExecuteNonQuery();

    DataSet ds = new DataSet();
    da.Fill(ds);
    return ds;
}

问题在于,名义上在 lo的每一个角落都是虚构的。如果你制定一份载有全球价值链所有价值观的扼杀清单,那么,在你们的WSBrand类别中,就更容易查阅。

EDIT:当你执行INSERT声明时,将返回的唯一东西是受影响的浏览次数。为了获得所有数据,你必须执行从Brands query处获得的选任证书,使你能够用数据填写数据集!

最后,《经济、社会、文化权利国际公约》:这应当充满希望。我改变了推力。浮标方法和插入方法。如果存在任何yn错,你就不得不做这些事,就像我在笔记本中所做的那样。 Good Luck

Answer 2

Simply use foreach loop:

foreach(DataGridviewRow a in DGV.Rows)
{
 string  nominal = Convert.ToString(a.Cells[1].Value)

    WSBrand insertInto = new WSBrand();
    insertInto.Insert(nominal)

}

友情链接