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...
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...
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...
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...
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...
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...
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 =...
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 =...
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.