Hi guys...can you help me please....
I'm using ASP.net, MSSQL 2005 and VB Script
I have don't know how to bind data in gridview control from database.
I want also to allow paging in gridview so I want to bind data using datatable or dataset...
Can you write the code for me in VB script?
Thank You in advance.....
User Profile
Collapse
-
VB Script:How to bind data in gridview using datatable
-
VB SCRIPT - How Do to Save the Gridview Data to MSSQL DB
Hello Guys,
Can You Help ME Please....
I'm Using VB scipt,Asp.net and MS SQL 2005
I have Temporary Data in my gridview and I want it to save in MS SQL DB...
For Example:
gridview field=Item Code
Data in Item Code Field= "Pencil2544 "
When I click the save button, the "Pencil2544 " from gridview will save to MS SQL DB.
DB:
Table Name=tblProduct... -
VB Script- How to Insert data from textbox to Gridview
Hi Guys,
can You help me please in my project....
I'm using VB Script,ASP.Net, MS SQL Server 2005
I want to save data in gridview control from data in textbox control....
How can I Do It?
When I type "Hello World" in Textbox, and click the save button the "Hello World" will in Gridview.
Thank You In Advance...
Help Me PLease... -
VB SCRIPT - Problem in Selecting data in Gridview Control
Hi Guys,
Can You Help Me PLease, I'm Currently facing Problems in my system...
I need some help...
I'm using VB script,ASP.net, MS SQL Server2005
I want to select a specific data in GridviewSummary , the specific data that I selected it will display the its details in GridviewDetails :
I have a 2 gridview the gridviewsummary and gridviewdetails :
gridviewsummary-contains Itemcode field(Primary... -
Passing the selected datakeyname is ok but the gridviewdetails was not displaying...
what should I do?
Here is the code:
-----------VB Code:-----------------------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s)
Dim con As New SqlConnection
con.ConnectionS tring = "Integrated Security=True;d ata source=ph-erwinm1;"... -
hi numena79 ,
Thank You for your support but I got an error when I write your code...
Can you help me please in debugging your code....
The errror is : "Constant Expression is Required"
The error is point out in vb script part of the code:
Const strSQL As String = "SELECT * FROM tblDetails WHERE ItemCode = " & itemCode
Thank you...Leave a comment:
-
Hey jeffstl thank you...
but i have a problem in binding data in gridview because of using SqlDataReader, I can't allow paging in my gridview because it is readonly, how can i allow paging in my gridview?
thank you...
please help...Leave a comment:
-
That is for GridItemCodeSum mary...How Can I write the code for GridItemcodeDet ails...Thank You...Leave a comment:
-
Can You write it in vb script?please.. .Thank You
I'm Using ASP.net and MS SQL2005 and I'm using VB SCRIPT
Here is my code:
Code: ( vbnet )
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s)
Dim con As New SqlConnection
con.ConnectionS tring = "Integrated Security=True;d ata source=ph-erwinm1;" & "persist...Leave a comment:
-
Thank You for your effort but still my problem is not answered.
I want to hard code it, I don't want to use wizard. My Problem is I'm using sqldatareader in binding data, many programmer said that you cannot edit or select or allow paging your gridview in using sqldatareader in binding data.
what should I do? Is there other way in binding data to gridview control so that i can select or allow paging in may gridview control.
...Leave a comment:
-
How To use datatable in displaying data in gridview from mssql db
hi guys,
can you help me please....
I'm using asp.net,mssql server2005 and vb script....
i dont know how to display data from db to gridview....
i want to use datatable in displaying data, so that i can edit,select and can allow paging to my gridview control.
Thank You in advance I appreciate your support...Leave a comment:
-
VB SCRIPT - How to Put Hypherlink in Gridview Field
Hi Guys,
Can You Help Me PLease...
I have a 2 gridview the gridview1 and gridview2:
gridview1-contains Itemcode field(Primary key)
gridview2-contains have Itemcode field(ForeignKe y)
gridview1-contains the summary of Items
gridview2-contains the details of items
I want to put Hypherlink in the Itemcode Field(Gridview1 ) for the selection of row of an specific item select,so that... -
How to allow paging in grid view control
Hi Guys,
Please Help ME....
I have a problem in displaying data in my gridview with paging, the data from the database is displaying to my gridview but I want to allow paging in my gridview.how can I do that?
I got an error msg that datareader does not allow paging in gridview....
because I use datareader in binding my data.
How can I convert my datareader to datatable using VB script so that I can allow paging... -
Hi jeffstl,
Thanks for your reply, I appreciate it, but I got an error when I write the code below.... The Error Message: Type 'System.data.sq lclient.reader' has no constructors
What should I do? can help me please to debug my code...I'm using MSSQL 2005 as my database and I used ASP.Net in developing the system and VB script.
thank you....
...Code:---------Name Space---------- <%@ Import Namespace="System.Data"
Leave a comment:
-
How To Get the data from MSSQL2005 database to display in GridView(VB.Net )
Hi Guys Can you help me please in my project, I have tblItemList in my SQL DB. I want to display all the data in my tblItemList in GridView control....
How Can I Do That in VB Script using VB.Net...
Thank you...
Please Help Me...Leave a comment:
-
How To Get the data from SQL database to display in GridView
Hi Guys Can you help me please in my project, I have tblItemList in my SQL DB. I want to display all the data in my tblItemList in GridView control....
How Can I Do That in VB Script using VB.Net...
Thank you...
Please Help Me...
Regards,
Jared
No activity results to display
Show More
Leave a comment: