HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND
PROGRAMING?
Answers were Sorted based on User's Feedback
Answer / manumole
SqlConnection conn = new SqlConnection("Data
Source=MYSERVER;Initial Catalog=Northwind;User
Id=sa;Password=sa;");
conn.Open();
DataTable dt=new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select
* from Employees", conn);
da.Fill(dt);
testGV.DataSource = dt;
Is This Answer Correct ? | 15 Yes | 8 No |
Answer / sai_sanju84@yahoo.com
we can fill grid view by using sqldataadapter and dataset.
the code will be as follows........
using System.data.sqlclient (add namespace)
in code part....
sqlconnection con=new sqlconnection("server=(the server
which u use);database=(database in which your table
located);user id=;password=");
sqldataadapter da=new sqldataadapter("select * from
table",con);
dataset ds=new dataset();
da.fill(ds);
gridview1.datasourse=ds;
gridview1.databind();
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / chandra kiran
i think we have to fill the gridview without using SQL datasource???
dataset ds=new dataset();
datatable dt =new datatable();
dt.tablename="SQL";
ds.tables.add(dt);
data column dc1=new datacolumn();
dc1.columnname="SNo";
dc1.datatype=Type.getType("System.Int32");
dt.columns.add(dc1);
//we are added 1 column to our datatable we can achieve this //1 in 1 statement in yhe following way
datacolumn dc2=dt.columns.add("Name",Type.GetType("System.String"));
//so now we have a table with 2 columns(SNo , Name)
//now we have add records to our table
datarow dr1=dt.newrow();
dr1[0]=1;
dr1[1]="kiran";
dt.rows.add(dr1);//we added 1 record
datarow dr2=dt.newrow();
dr2[0]=2;
dr2[1]="varma";
dt.rows.add(dr2);//in the same way we can add rows better //use arrays
//now we have a dataset and a datatable(SQL) inthat one and //this datatable contains two columns & 2 records now we //have to bind this 1 with our gridview
gridview.datasource=ds.tables[0] ;or
gridview.datasource=ds.tables["SQL"];or
gridview.datasource=dt;
output in gridview like
---------------------------------
SNo Name
---------------------------------
1 kiran
2 varma
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / srikanth chodavarapu
Drag and drop the table on browser,difultly it shows grid
view ..
Is This Answer Correct ? | 6 Yes | 7 No |
How to perform sorting on a table in ADO.NET?
0 Answers Petranics Solutions,
What are all components of ADO.Net data provider?
What are the steps to connect to a database?
Explain advantages of ado.net?
How to aggregating data across related tables?
What are the major difference between classic ADO and ADO.NET?
Explain the difference between sqlcommand object and command behavior object?
What Is Difference Between Ado And Ado.net?
What is the role of data provider in ado.net?
Explain how to create dynamic gridview?
Name which operations can you not perform on an ado.net dataset?
How to retrieve the third table value from the data set?