gris view and sql id (have to set without GUI)
-
there are a grid view and sqldata sourceid in my code defined previously. can i use it for any sql query? or i have to create some another???
-
there are a grid view and sqldata sourceid in my code defined previously. can i use it for any sql query? or i have to create some another???
it all depends on your needs .... for example: If you have a query like this in your SqldDataSource to display the data to the Gridview :
select * from TableMasterCity
then you can use it to Bind dropdownlist or other control. it all depends on the manufacture of the SQL query that you created and the need for its control.
-
it all depends on your needs .... for example: If you have a query like this in your SqldDataSource to display the data to the Gridview :
select * from TableMasterCity
then you can use it to Bind dropdownlist or other control. it all depends on the manufacture of the SQL query that you created and the need for its control.
i need to call like select * from temp c1,c2,c3 where c1='17/nov/2011' is there any restriction to use specific data type??means when we create a grid view or sql data id we have to define data type of columns or not?
-
i need to call like select * from temp c1,c2,c3 where c1='17/nov/2011' is there any restriction to use specific data type??means when we create a grid view or sql data id we have to define data type of columns or not?
I think,if you want show all colums in GridView, you can define columns or not..both it's yes can... If you dont want define columns in gridview,you can set Autogeneratecolumns=true in Properties Gridview ,and result will show data column c1,c2,c3.. If you set Autogeneratecolumns=false,you must define columns in gridview..
-
i need to call like select * from temp c1,c2,c3 where c1='17/nov/2011' is there any restriction to use specific data type??means when we create a grid view or sql data id we have to define data type of columns or not?
if for Gridview and SqlDataSource, I guess you do not need to define its data type colum can, ...
-
if for Gridview and SqlDataSource, I guess you do not need to define its data type colum can, ...
thanx a lot...