如何保存gridview记录到数据库 [英] how to save the gridview recordsto database

问题描述

我的运行模式如下





Gridview如下;



Facid 1 2 3 4 5



1 dropdownlist1 dropdownlist2 dropdownlist3 dropdownlist4 dropdownlist5

（好/公平/差）（好/公平/差（好/公平/差）（好/公平/差）（好/公平/差）



2 dropdownlist6 dropdownlist7 dropdownlist8 dropdownlist9 dropdownlist10

（良好/公平/差）（良好/公平/差）（良好/公平/差）（良好/公平/差）（良好/公平/差）





i想要将上面的gridview记录保存在数据库中。





在数据库表结构中如下



Facid R1 R2 R3 R4 R5



1好公平好公平好

2好公平好公平好



为什么我在asp.net中使用c＃。

my run mode as follows


Gridview as follows;

Facid 1 2 3 4 5

1 dropdownlist1 dropdownlist2 dropdownlist3 dropdownlist4 dropdownlist5
(good/fair/poor) (good/fair/poor)(good/fair/poor) (good/fair/poor) (good/fair/poor)

2 dropdownlist6 dropdownlist7 dropdownlist8 dropdownlist9 dropdownlist10
(good/fair/poor) (good/fair/poor)(good/fair/poor) (good/fair/poor) (good/fair/poor)


i want to save the above gridview records in database.


In database table structure as follows

Facid R1 R2 R3 R4 R5

1 good fair good fair good
2 good fair good fair good

for that how can i do in asp.net using c#.

推荐答案

这是解决方案。请根据您的要求进行更改。

Here is the solution. Please make the changes as per your requirement.

using(SqlConnection connection = new SqlConnection(@"data source=ABC; persist security info=True;initial catalog=ini"))
{
    using(SqlCommand command = new SqlCommand(sql, connection))
    {
        try
        {
            connection.Open();
            for (int i =0; i< gridView1.RowCount; i++)
            {
                SqlParameter parameter = new SqlParameter();
                                parameter.ParameterName = "@Num";

                parameter.SqlDbType = SqlDbType.NVarChar;
                parameter.Direction = ParameterDirection.Input;
                parameter.Value = Convert.ToString(gridView1.GetRowCellValue(i, "Number"));


                command.Parameters.Add(parameter);
            }
            command.ExecuteNonQuery();
        }
        catch(Exception)
        {

        }

    }


}

干杯，

Praveen Nelge

Cheers,
Praveen Nelge

这是解决方案



link 1

link 2

这篇关于如何保存gridview记录到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！