How can I pass the value from pop up menu to column gridview? In my gridview I have a link button which will open another page which has a gridview also. After I click an item to the pop up menu gridview, the data selected should copy to the parent page inside column gridview. note: this gridview is a third party which is obout. To make it clear, please see the attached image. http://i44.tinypic.com/4socgk.jpg[^]

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

nope, this is not vb.net, this is MS Access, that is why you cannot see an oledbcommand.yes, I'm using old recordsets. You can't see open connection because in the Form1 properties, it has recordsource, also in form open. If i will use oledb connection, how can i add the data's in my continuous form? This project is an .adp(microsoft access project),which means if you open the myproject.adp, it is already connected to database.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

no. the update is on the form. Using the Continuous Forms The same as GridiView in visual basic. In detail of continuous form, I have textboxes and checkboxes, if I check the checkbox, the table is automatically updated. Database update is not on the code, its on the form.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

thanks. i check the db2 and it has the same table. is my approach correct? i mean connecting other database in an access form. here is my snippet code: ACCESS FORM

'Default database DB1
Private Sub Form_Open(Cancel As Integer)
Dim ssql As String

ssql = "SELECT \[tbl1\].id, \[tbl1\].code,\[tbl1\].mflag, \[tbl2\].cdnum, \[tbl3\].bname"
ssql = ssql & " FROM  \[tbl1\] INNER JOIN"
ssql = ssql & " \[tbl2\] ON"
ssql = ssql & " \[tbl1\].id = \[tbl2\].id INNER JOIN"
ssql = ssql & " \[tbl3\] ON \[tbl1\].code = \[tbl3\].code"
ssql = ssql & " WHERE \[tbl1\].mdate ='2011/10/12'"
Me.RecordSource = ssql

Me.UniqueTable = "tbl2"

End Sub

'option to select DB1 or DB2
Private Sub optSel_AfterUpdate()
Dim ssql As String

'DB1
If Me.optSel = 1 Then
    ssql = "SELECT \[tbl1\].id, \[tbl1\].code,\[tbl1\].mflag, \[tbl2\].cdnum, \[tbl3\].bname"
    ssql = ssql & " FROM  \[tbl1\] INNER JOIN"
    ssql = ssql & " \[tbl2\] ON"
    ssql = ssql & " \[tbl1\].id = \[tbl2\].id INNER JOIN"
    ssql = ssql & " \[tbl3\] ON \[tbl1\].code = \[tbl3\].code"
    ssql = ssql & " WHERE \[tbl1\].mdate ='2011/10/12'"      
Else 'DB2
    ADODisconn 'disconnect to DB1
 
    ADOConDB2  'connect to DB2        
    
     ssql = "SELECT \[tbl2\].id,\[tbl2\].code,\[tbl2\].mflag,\[tbl2\].cdnum,\[tbl3\].bname"
     ssql = ssql & " FROM  \[tbl2\] INNER JOIN \[tbl3\] ON "
     ssql = ssql & " \[tbl2\].code = \[tbl3\].code"
     ssql = ssql & " WHERE \[tbl2\].id > 160" 
End If

Me.RecordSource = ssql
Me.UniqueTable = "tbl2"

End Sub

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Apologize if I post this on the wrong forum. In ACCESS, I have Form Open event that will connect to DB1 and datas will show on the detail records. The form has a Uniquetable = "tableEmp". Now, I have a option button that will change database to DB2, Note: DB1 and DB2 all tables are the same. In the form details I have checkbox, if I will checked the checkbox the tables update automatically, and it will update because of the uniquetable but If I will change the database the tables will not update. what's cause of this? thanks in advance,.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

how can i read the datareader backward. let say i have data number=1,2,3,4,5,6,7,8,9,10.

dr(number) 'i want result start at 10.

in dataset,

ds.Tables(0).Rows.Count - 1 To 0 Step -1

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

thank you for quick reply. i found out also that if i will not put dr.read in an if statement, it causes an error. weird. like this... if dr.read then while.... endif

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Is there any workarounds on how to read the data from sql join using sqldatareader.

query ="SELECT TABLE1.FID FROM TABLE2 WHERE TABLE1.ID = TABLE2.ID" ---StoredProcedure

Dim sqlRead As SqlDataReader

cmd.CommandType = CommandType.StoredProcedure
sqlRead = cmd.ExecuteReader

While sqlRead .Read()
Dim str as String = sqlRead("FID") '-------> error here!
End While

Yes, I know that the good solution is to put "AS" clause on query. Let say, TABLE1.FID AS FID. But the problem is I have 100 StoredProcedures and each has no alias. It's very difficult if I will modify all the SP just to put that clause. Thanks in advance

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Hi mates, I have a website and my boss wants to have 3 language. In a login page there will be a dropdown list (English,Japanese,Chinese) after the password box. The problem is, I don't know how to code it, anyone have idea would be much appreciated. They want to put in excel file. So that they can easily add/modify a word or sentence. I've read and search in google but result is only using the .resx files. Thanks in advance.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Hi all, In access, we can print multiple report in a single button, how to do that in asp.net? I'm using report viewer. I really appreciate who can gave me a detailed solution. I ask already google. Thanks in advance!

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

sorry, i figure out already, i just create two connection string. thanks

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

hi, i can change the web.config at run-time because its just like a text file. is my approach is good thing to change at run-time? the goal is to change database when the user clicks a radiobutton, let say, rdoDB1 and rdoDB2. the problem is grid are not reflecting to the new database but when i close the page then start again, grid shows data with new database which set in web.config. thanks in advance for your time.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

thanks Eddy Vluggen

Eddy Vluggen wrote:

Next time, include the message of the error. It can be quite helpful.

the subject itself of this post is error message of my program. but you gave me an idea what is the real error which is the inner exception, and i found out that some process are not close or dispose. so i added a kill process, and it goes smoothly and perfectly. thanks you very much.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

thanks prdshukla i think no other users who use the db because its a local machine and only 1 user, and in the end of my code I set to nothing the server.

resDB.SqlRestore(sv)
sv.Refresh()
sv = Nothing

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

hi everyone, I always got an error Restore failed for Server '...\SQLEXPRESS' I googled it already and bunch of result. but still, i can't solve it. Details: *windows xp *sql server 2005 using PCNAME\SQLEXPRESS, (windows authentication mode) *visual studio 2005 *filePath= C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DBNAME.bak note: sometimes it goes successfully but sometimes got an error. please help! thanks in advance. here's the code

Using cnn As New SqlConnection(constrSQL)
cnn.Open()
dbName = cnn.Database.ToString()
cnn.ChangeDatabase("master")
Dim sc As New ServerConnection(cnn)
Dim sv As New Server(sc)
' Create backup device item for the backup
filePath = Path.Combine(filePath, databaseName & ".bak")
Dim bdi As New BackupDeviceItem(filePath, DeviceType.File)
' Create the restore object
Dim resDB As New Restore()
resDB.Database = dbName
resDB.Action = RestoreActionType.Database
resDB.ReplaceDatabase = True
resDB.NoRecovery = False
resDB.Devices.Add(bdi)
resDB.PercentCompleteNotification = 10
AddHandler resDB.PercentComplete, AddressOf ProgressEventHandler
resDB.Database = dbName
' Restore the database
Try
resDB.SqlRestore(sv)
sv.Refresh()
sv = Nothing
Catch ex As Exception
log.Debug(ex.ToString)
Throw (ex)
End Try
End Using

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

hi experts, I have rdlc report in asp.net which has two datasource and it added in report data sources list as 'ds_WKSG' and 'ds_WKBC'. The problem is it only works when I use either one of them. If I will add the second datasource onto my report it gives an error 'A data source instance has not been supplied for the data source ds_WKBC'. I googled it already but my case is different. i read already here.. [^]my case is I want to use to datasource in one report. thanks in advance.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Hi, Is there a way to check if email is send or not in vb.net? I have a program which will send an email using ms outlook. When ever the user click the Email button on my vb.net form. The email outlook message will display with it's recipients, subject and body. Then user will just click the send button after the user adds body information. Now,I want to trap if user click the send button in email outlook form. I want this so that if the user click the send button in email outlook, I will automatically close the vb.net form. Thanks in advance!

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Hi mates, I'm trying to create a gridview with merging cells and an edit button on every column, not on row. When clicking the edit button, it will show a dropdownlist then the edit button will change to save/cancel. I've search already in google, lots of results on merging cells but my case is different. To make it clear. please see attached file. [i_want_to_create_gridview_like_this!] Thanks in advance.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Yeah, I know that doing a multiple gridview is not a good design,it's heavy. I used gridview because I want to update the 2nd column by clicking on it and I have a link on the 1st column. Showing/updating multiple column in listview is not possible.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Hello experts, I've tried to create a multiple dynamic gridview during page load. Because I've create about 20 gridview in one page. I've loop it and put it on a placeholder and bind it. There are only 2 columns per grid. The grid height is only 90px,so its small. The data per grid is only 50-100 per rows. I also added an OnRowCreated and OnRowDataBound event per grid. But when I run my project, it takes about 1-2 minutes to load all the grid. If I will remove the OnRowCreated and OnRowDataBound. Very fast. Is there a solution on how to make the page load including the 2 event as fast as 5-10 seconds? I use the Update Panel. Any help would be greatly appreciated. Thanks!

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」