No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi There, I am trying to retrieve the data from MS Access Table to LIST-VIEW, its difficult for me to write the code as I am beginner, Need help on this .. Any suggestions, example or template ? Thanks in Advance.. |
|
Hi There, I am trying to get the Sum values of a Column and want to check if entered value in Textbox is valid. Here is my code below [CODE]mystr = ("Provider=Microsoft.JET.OLEDB.4.0;" & _ "Data Source=K:\Amrut Diary\Amrut_Diary\ADDB.mdb") con = New OleDb.OleDbConnection(mystr) con.Open() strsql = "SELECT SUM(Available_Stock) As Avstk FROM STOCKDB … |
|
Re:
Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New … |
|
Re:
need help on this; I want to have the textbox4 to have the sum of columns based on their employee Id. I have this code but kept getting error. strsql = "SELECT emp_id, COUNT(acdcalls) FROM CMS WHERE emp_id= '" & TextBox1.Text & "'" oledbcon.Open() Dim cmd As New OleDbCommand(strsql, oledbcon) … |