Code:
YourReport.SetParameterValue("ReportParameter", TetxBox.Text)
MySqlCommand = New SqlCommand("SELECT * FROM Tbl_Product_Definition_1 join Tbl_PO_Item ON Tbl_Product_Definition_1.P_Article_No = Tbl_PO_Item.F_Article_No join Tbl_PO ON Tbl_PO_Item.F_PO_No = Tbl_PO.P_PO_No join Tbl_Payment ON Tbl_PO.P_PO_No=Tbl_Payment.P_OR_No WHERE Tbl_Payment.F_Member_Code='"
conn = GetConnect()
Dim mycommand As SqlClient.SqlCommand = New SqlClient.SqlCommand()
mycommand.Connection = conn
mycommand.CommandText = "Update Tbl_Member_Profile set F_Name='@F_Name', M_Name='@M_Name', L_Name='@L_Name', Date_Of_Birth='@Date_Of_Birth', Membership_Category='@Membership_Category', Age='@Age', F_Recruiter_Member_Code='@F_Recruiter_Member_Code',
conn = New SqlConnection("Data Source=192.168.14.40;Initial Catalog=Northwind;User ID=sms;Password=passw0rd")
conn = GetConnect()
Dim sda As New SqlDataAdapter
Dim dset As New DataSet3
Dim qury As String = "SELECT F_Article_No, Article_Color,
If grid_selected_item.Rows.Count = 0 Then
grid_selected_item.Rows.Add(txt_article_name.Text, txt_color.Text, txt_size.Text, txt_qty.Text, lbl_selling.Text, txt_discount.Text, GROSS, Total_net, cur_qty, lbl_art_no.Text)
Else
For ichk As Integer = 0 To grid_selected_item.Rows.Count - 1
Leave a comment: