Comments by mrukr (Top 22 by date)

Hello Sohail

How could I display row number to a textbox when is row is selected on the datagrid OR how can I display row number if datagrid itself?
Thank you for helping me bud

It allows null and also type NULL in there ,I believe its taking integer only....

It allows null and also type NULL in there ,I believe its taking integer only....

its adding zero in everyfield that in integer if I insert nothing

that's when I do insert a new row..

How can I avoid it adding 0 instead leave it blank.

Thanks

Hello Sohail hope you are doing okay.


For my update button, Some fields are empty (for INT column) but its returning 0 in the Database tables and fields for integers,how can I just leave them blank instead of 0???
Please help thanks buddy.

Dim str As String = textbox1.text
If str.Contains("FROM"C) Then
Dim index As Integer = str.IndexOf("FROM"C)
Dim result As String = str.Substring(0, index)
Console.WriteLine("result: " & result)
End If

im not sure if this is not working for the result

I need now update delete update save after this query has been executed from codes below..Can you help plz.thanks

If TextBox1.Text <> "" Then
Dim con As New SqlConnection(DBsPath)
Try
con.Open()
Dim sqlCmd As New SqlCommand()

sqlCmd.Connection = con
sqlCmd.CommandType = CommandType.Text
sqlCmd.CommandText = TextBox1.Text
Dim sqlDataAdap As New SqlDataAdapter(sqlCmd)

Dim dtRecord As New DataTable()
sqlDataAdap.Fill(dtRecord)
DataGridView1.AutoGenerateColumns = True
DataGridView1.DataSource = dtRecord
DataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells)
con.Close()

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

Else
MessageBox.Show("Please type correct SQL Query")
End If
End Sub

sohail thanks buddy

below are my codes :so I need to add delete and update button to work within the datagrid view..

Sohail thanks so much on this project..
may be you can assist me on this one too.

Now I have another button that can execute any query from a text box.Below find my codes for that button.
but now I need to able to save update and delete after running the query .
How can I proceed with this.Please help

Sohail thanks so much on this project..
may be you can assist me on this one too.

Now I have another button that can execute any query from a text box.Below find my codes for that button.
but now I need to able to save update and delete after running the query .
How can I proceed with this.Please help

So how do I make update and save but ignoring first column first firt row cell.

they work pretty good.
but I need to do save and insert button but it to start from second column or second row.
as first column is automatically generated.Pleasse help sohail.

you are very good..god bless!

Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


Call ReadTables()

End Sub


Private Sub ReadTables()
Dim con As New SqlConnection(DBsPath)
Dim com As SqlCommand = Nothing
Dim dr As SqlDataReader = Nothing
'Dim schemaTable As DataTable
Try
ComboBox1.Items.Clear()
con.Open()

'Get table and view names
com = New SqlCommand("SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE ='Base Table'order by 'TABLE_NAME' asc", con)
dr = com.ExecuteReader(CommandBehavior.CloseConnection)
If dr.HasRows Then
While dr.Read
ComboBox1.Items.Add(dr.Item("TABLE_NAME"))
End While
End If
dr.Close()
Catch ex As Exception
If con.State = ConnectionState.Open Then
con.Close()
End If
End Try
End Sub


Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click



If ComboBox1.SelectedIndex > -1 Then

Dim con As New SqlConnection(DBsPath)
Try
con.Open()
Dim sqlCmd As New SqlCommand()

sqlCmd.Connection = con
sqlCmd.CommandType = CommandType.Text
sqlCmd.CommandText = "select * from " + ComboBox1.SelectedItem
Dim sqlDataAdap As New SqlDataAdapter(sqlCmd)

Dim dtRecord As New DataTable()
sqlDataAdap.Fill(dtRecord)
'DataGridView1.AutoGenerateColumns = True
DataGridView1.DataSource = dtRecord
'DataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells)

con.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)

End Try
Else
MessageBox.Show("No tables selected")
End If

sohail thanks buddy

below are my codes :so I need to add delete and update button to work within the datagrid view..

plz could you help me following my codes
just having a hard time.

I have my tables loading and showing on grid uusing codes below now I need to make button to save changes and delete any data.
thanks

how do i use a button to delete or save the data on the grid??

Thanks so much for your help

how do i use a button to delete or save the data on the grid??

Thanks so much for your help

Basically how can I display the list of all tables of the database on a form (mine populated table list in combobox) then select any of these tables that would populate all data in dataview grid.Codes above is where I am stuck?
any advise or help would be greatly appreciated?