ok i have 2 datagrids...i am posting the entire code of the entire webform..check it out
[code=vbnet]
Dim myConnection As SqlConnection
Dim myCommand1 As SqlCommand
Dim myCommand2 As SqlCommand
Dim ra As Integer
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here...
tanya2001
Last Activity: Dec 10 '07, 03:50 PM
Joined: Nov 15 '07
Location:
-
hi
i have another webform in which on clicking a button a datagrid with data is displayed..now wen i m using update in it..wen i click edit..its going back 2 same page without datagrid...i cannot write d code in page_load event...coz i want d data 2 b displayed only aftr clicking a button...what do i do now?...Leave a comment:
-
tanya2001 started a topic VB.NET -Web App: Problems Displaying DataGrid On Editing of Another DataGridin .NETVB.NET -Web App: Problems Displaying DataGrid On Editing of Another DataGrid
hi m bac 2 trouble u agn
can u tell me how do i update a datagrid which has got a datagrid which is displayed on a button click and thn it tht datagrid thr's a link which has 2 be updated...wen m clicking edit on the datagrid nothing is returning back...what shud i give in the page post back event?i cant give d code for datagrid coz tht shud b displayed only when a button is clicked...wwhat do i do... -
hi
can u tell me if i can just add the values from a column based on 2 conditions and display d values in a different table?...Leave a comment:
-
tanya2001 replied to VB.NET -Web App: How to transfer data from MS Excel database to SqlServer 2000 databain .NET[code=csnet]
private void Button1_Click(o bject sender, System.EventArg s e)
{
string excelConnection String = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=Book1.xl s;Extended Properties=""Ex cel 8.0;HDR=YES;""" ;
// Create Connection to Excel Workbook
using (OleDbConnectio n connection =new OleDbConnection (excelConnectio nString))
{
...Leave a comment:
-
tanya2001 replied to VB.NET -Web App: How to transfer data from MS Excel database to SqlServer 2000 databain .NETi didnot understand wat u said:-(...Leave a comment:
-
i wanted to know tht the below code shows the connection string for excel
Dim conStr As String = "provider=Micro soft.Jet.OLEDB. 4.0;data source=" + fileName + "; Extended Properties=Exce l 8.0;"
abd now here below agn asks for d same excel connection...wh ere do v have 2 give the sql connection string
MyConnection = New System.Data.Ole Db.OleDbConnect ion(connections tring)...Leave a comment:
-
hi can u plz elaborate the code more plzz coz m all new 2 .net so i dunno much abt it...so can u plz...my excel sheet name is sheet1 and sql table name is table5...Leave a comment:
-
urgent-transferrring data from excel to sqlserver using webforms
hi all
can somebody plzz tell me how to transfer data from excel 2003 to sql server 2000 using webforms.
I have a table in excel and i want to transfer the entire data into sqlserver table...how can i do it plzzz help me -
tanya2001 started a topic VB.NET -Web App: How to transfer data from MS Excel database to SqlServer 2000 databain .NETVB.NET -Web App: How to transfer data from MS Excel database to SqlServer 2000 databa
ok no prob ok atleast can u tell me how to transfer data from msexcel to sqlserver 2000 using webforms??plzzz z... -
hi there i have a new query...jts go 2 this link n help me out plzzz
http://www.thescripts. com/forum/showthread.php? p=2943265#post2 943265...Leave a comment:
-
displaying columns vertically n horizontally using crystal reports
hi all
now i have a query on crystal reports in .net.I have to generate a report in my webform by displaying one column vertically and other one horizontally... .so how do u suggest...i should use it....i knw tht v do using d formula in crystal reports in .net but i have no idea of the formulae used in it....can somebody plzz help me generate this reports...thanx in advance.. -
i got the answer i was just doin a simple mistake by giving a wrong textbox name....thanx 4 ur help anywayz.. posting a new query on crystal reports...help me out if u can in it...tc...Leave a comment:
-
alright..but wen i was using the 1st 2 fields it worked wen ma dding these 2 new fields in d same way its not working..though wen i comment them n work d first 2 still work..though all of them have been initialized d same way.......Leave a comment:
-
hi yes its related 2 this so m posting it here
well d first 2 field in this r getting updated but then wen i have added 2 more fields in this its not updating...y is it so?
m giving u d code below
[code=vbnet]
Dim Stocksent1 As TextBox = CType(e.Item.Fi ndControl("Text Box2"), TextBox)
Dim Signed1 As TextBox = CType(e.Item.Fi ndControl("Sign edTextBox"), TextBox)
...Leave a comment:
-
yes i got it thanx a heap....thanks alot i was rely worried abt this...
can i ask u another qeury on my project plzz...Leave a comment:
-
hiya sorry to bother u
but can u plz write down the code for me as m all new 2 .net i dunno much abt this plzzzz...n yippeee i have finally learnt the code tags....(cheers 2 u)...Leave a comment:
-
hi i did it but its like showing me a blank page wehn i click edit...y is it so???...Leave a comment:
-
lol....hi
well i did write it the way u said as shown below but when i click the edit link its just showing me a blank page the datagrid disappears...th e entire code for the page is shown below( i hope i m right this time :-))
[code=vbnet]
Imports System.Data.Sql Client
Public Class trial
Inherits System.Web.UI.P age
Dim myCommand1 As New SqlCommand
Protected WithEvents LinkButton4...Leave a comment:
-
[Code=VBNET]
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
Dim cn As New SqlConnection(" Server=SERVER;u id=sa;pwd=;Data base=Central")
Dim da As New SqlDataAdapter( "select * from Table3 where Lognumm= '" & Request.QuerySt ring("ID") & "' and Flag=1", cn)
Dim dt As New DataTable
...Leave a comment:
No activity results to display
Leave a comment: