-
-
-
-
-
-
How to convert the data present in MS-Access to SQL server 2000?
mkatpatal
- Jul 24th, 2006
use data transformation services of sql server.or create a new database insql server in console. then right click it, all tasks, import data and then the sql server will guide u to choose driver, choo...
-
I have developed a software when i am going to run it after installing it works very well, but while trying to access the reports then it gives error messages showing "not register something like that...." plz help me to solve out this problem and how?
-
-
conn.Open()
cmd = New SqlCommand
Dim InsertString1 As String
Dim txt_batchno(i) As TextBox
txt_batchno(i) = New TextBox
'txt_batchno(n).Text = txtbatchno.Text
n = txt_nos.Text
' For i = 0 To i = n - 1
'compvar(i) = txtbatchno.Text
' Next
' MsgBox("value of compvar(i)" & compvar(i).Item(i))
'MsgBox("value of compvar(i)" & compvar(1))
'For i = 0 To i = n - 1
i = 0
' If i <= n - 1 Then
' MsgBox("value of compvar(i)" compvar(i))
compvar(i).Item(i) = New ArrayList
Dim s1 As String
txt_batchno(i).ext = compvar(i).Item(i)
s1 = compvar(i).Add(txt_batchno(i).Text)
' MsgBox("value of compvar(i)" & compvar(i).Item(i))
txt_batchno(i).Text = s1 'compvar(i)compvar(i).Item(i).ToString
InsertString1 = "select * from brakedisc_info where batchno='" & txt_batchno(i).Text & "'" ' and batchno='" & txt_batchno(i + 1).Text & "'"
compareDS = New DataSet("compare")
DA = New SqlDataAdapter(InsertString1, conn)
DA.Fill(compareDS, "brakedisc_info")
DataGridView1.DataSource = compareDS.Tables(0)
'i = i + 1
' End If
'Next
End Sub
Private Sub btn_add_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_add.Click
conn = New SqlConnection("server=acer;initial catalog=breakdiskprocessdata;integrated security=sspi")
conn.Open()
n = txt_nos.Text
Dim InsertString1, s1 As String
Dim txt_batchno(i) As TextBox
txt_batchno(i) = New TextBox
Dim flag As Boolean
flag = True
i = 0
compvar(i) = New ArrayList
'For i = 0 To i = n - 1
If flag = True Then
If i <= n - 1 Then
compvar(i).Insert(i, txtbatchno.Text)
txtbatchno.Text = ""
Me.Show()
MsgBox("array contains:" & compvar(i).Item(i))
i = i + 1
End If
End If
' Next
' If i <= n - 1 Then
'flag = False
' If flag = False Then
'InsertString1 = "select * from brakedisc_info where batchno='" & txt_batchno(i).Text & "'" ' and batchno='" & txt_batchno(i + 1).Text & "'"
'MsgBox("value of compvar(i)" & compvar(i).Item(i))
' txt_batchno(i).Text = compvar(i).Item(i)
' InsertString1 = "select * from brakedisc_info where batchno='" & txt_batchno(i).Text & "'" ' and batchno='" & txt_batchno(i + 1).Text & "'"
' compareDS = New DataSet("compare")
' DA = New SqlDataAdapter(InsertString1, conn)
' DA.Fill(compareDS, "brakedisc_info")
' DataGridView1.DataSource = compareDS.Tables(0)
' End If
' End If
End Sub
End Class
Thanks in advance...
">How to assign and retrive values from array, arraylist dynamically........please see the questionWill enter the number of values to be inserted into array in one text boxex: n= txt_num.textand from another textbox I want to insert the 'n' values(ie varchar values)and then i want to retrive the values back such that i can use these values in select stmt of T-sql to retrive the data....and i want to display the data of all 'n' values in one table*here is the code.. for assigning and retriving pl chk this is the main prob...i can write T-sql part..........please helpImports System.Data.SqlClientImports System.DrawingPublic Class compare Dim n, i As Integer Dim compareDS As DataSet Dim compvar(i) As ArrayList Dim conn As SqlConnection Dim cmd As SqlCommand Dim DA As SqlDataAdapter Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click conn = New SqlConnection("server=acer;initial catalog=breakdiskprocessdata;integrated security=sspi") conn.Open() cmd = New SqlCommand Dim InsertString1 As String Dim txt_batchno(i) As TextBox txt_batchno(i) = New TextBox 'txt_batchno(n).Text = txtbatchno.Text n = txt_nos.Text ' For i = 0 To i = n - 1 'compvar(i) = txtbatchno.Text ' Next ' MsgBox("value of compvar(i)" & compvar(i).Item(i)) 'MsgBox("value of compvar(i)" & compvar(1)) 'For i = 0 To i = n - 1 i = 0 ' If i
-
Error in C#.Net : type or namespace could not be found (are you missing a using directive or assemble reference).Can you tell me how to solve this error?
mkatpatal
- Jul 24th, 2006
Whereever u hv got this error(line no), see which reference is required.in the solution explorer, click references. right click and add the references. Now again build prg.
-
-
-
-
-
How to stop a form refresh in vb.net windows application
hi all,I am used in me.showintaskbar property to remove application from taskmanager.but it removes the form(application)it still refreshes.How to stop the form refresh.to avoid that issue please help me.Thanks,
VB.NET Interview Questions
Ans