Search results

  1. M

    Question How to get Selected Index of Datagridviewcombobox column.

    Can anybody help to let me know that How can i get the Selected index of Datagridviewcombobox column in vb.net 2010. Thanks
  2. M

    Question How to append records in master detail tables.

    I create a program in vb.net 2010 with sql Server 2014, There are two tables InvoiceMaster and InvoiceDetail A invoice contain 100 item. I inserted 60 items in the tables through follwoing code: Private Sub BtnSave_Click(sender As System.Object, e As System.EventArgs) Handles BtnSave.Click...
  3. M

    Question How to Pick specific portion of a string

    Thank u very much for your explanation, Yes exactly I want The text of any length and any type between the first and second slash, I mentioned in quouts "123a", But you are absolutely right it does not clarify that only 123a is required or the text between two slashes is required. sorry for...
  4. M

    Question How to Pick specific portion of a string

    I have a string like dim mystr as String= 'A-001/123a/20' I want to pick "123a" only from mystr using VB.NET how can I ? Thanks in advance.
  5. M

    Question How can I read DataTable rows one by into a DatagridView

    Instead of assigning Datagridview.datasource =MyDataTable , I want to read DataTable rows one by one into Datagridview (Due to some reasons). I tried as under but it shows the last row only. can any body help pls? Private Sub BtnShowBills_Click(sender As System.Object, e As...
  6. M

    Question how to check datagridviewimagecolumn is null or not ?

    Dear Thank u very much your explanations and info. It's my mistake that i could not understand correctly, perhaps because of Little knowledge of vb.net. anyhow now I change the code like : If IsDBNull(Dgv1.CurrentRow.Cells("PictureDataGridViewImageColumn").Value) Then 'DataGridViewImageColumn...
  7. M

    Question how to check datagridviewimagecolumn is null or not ?

    Dear Thank u for ur information, I m not so expert in vb.net and is new, however, i tried to use code like If IsDBNull(Dgv1.CurrentRow.Cells("PictureDataGridViewImageColumn").Value) Then 'DataGridViewImageColumn Me.ProductPicture.Image = Nothing...
  8. M

    Question how to check datagridviewimagecolumn is null or not ?

    Thnx for ur reply, I changed my code as under and its working as desired. If IsDBNull(Dgv1.CurrentRow.Cells("PictureDataGridViewImageColumn").Value) Then Me.ProductPicture.Image = Nothing Else Dim pCell As New DataGridViewImageCell...
  9. M

    Question how to check datagridviewimagecolumn is null or not ?

    I m using this code to Put image from Datagridviewimage column to Picturebox Private Sub Dgv1_CellDoubleClick(sender As Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles Dgv1.CellDoubleClick try Dim pCell As New DataGridViewImageCell pCell =...
  10. M

    Question How to SqlTransaction?

    Thanks dear, its working now.
  11. M

    Question How to SqlTransaction?

    Dear Thank u very much for ur reply. I tried as per ur reply, this is my code how i tried. Private Sub BtnSave_Click(sender As System.Object, e As System.EventArgs) Handles BtnSave.Click If PurchaseGrid.Rows.Item(0).Cells(0).Value = "" Or PurchaseGrid.Rows.Item(0).Cells(2).Value =...
  12. M

    Question How to SqlTransaction?

    Aslam o alikum I m using vb.net 2010 with sql server 2014, at present I m inserting the data in three tables with following code Private Sub BtnSave_Click(sender As System.Object, e As System.EventArgs) Handles BtnSave.Click If PurchaseGrid.Rows.Item(0).Cells(0).Value = "" Or...
  13. M

    Question How to Insert Null Value to Image column?

    Dear Thank you very much for corrections and information as well. You code works very fine and as desired. Once again thank u very much for ur help.
  14. M

    Question How to Insert Null Value to Image column?

    Thanks for u reply. I am using dataTable below is the vb.net code through which i tried to to insert the null value. Data type of column is Image (sql Server 2014) cmd.Parameters.AddWithValue("@Picture", ProductPicture.Image).Value = System.DBNull.Value
  15. M

    Question How to Insert Null Value to Image column?

    Asalm o alikum I m using vb.net 2010 with sql server 2014, In my product table I have an image column to save product picture. In case i don't have picture for a product i want to insert a null value. i tried to insert with dbnull.value but faild. can any body help me in this regard. thanks
Top Bottom