Tarang Raval

Dim search As New Recordset b = "SELECT * FROM student WHERE std=" & "'" & cmbsd.Text & "'" & " AND admin=" & "'" & year.Text & "'" & "" search.CursorLocation = adUseClient 'search.Open q, cn, adLockOptimistic, adOpenStatic search.Open b, cn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = search this code …

cn.Execute ("ALTER TABLE subject ADD COLUMN '" & txtsub.Text & "' number;") this query is excute to the add column but query bis excuted text value is not pass but null value will be pass how i textbox text add column please anybody give me solutation

i am search in table admin columns admin columns current year display in the system admin columns datatype is DATE/TIME please give me sql query

am student please answer me please this form use combobox change event use this code serch data show in datagrid If cmbsd.Text = "1" Then q = "select *from student where std=" & cmbsd.Text & " AND admin=" & year.Text & " " r.CursorLocation = adUseClient r.Open q, cn, adOpenDynamic, …

Private Sub cmbsd_click() If cmbsd.Text = "1" Then q = "select *from std1 where year=" & year.Text & " " r.CursorLocation = adUseClient r.Open q, cn, adOpenDynamic, adLockOptimistic Set DataGrid2.DataSource = r