Sulaiman_1

1.Get the name(data) from RFID to frm.name 2.Select data from the access using SQL query ex: select * from tblname where name='" & (name from frm.name) & "' Hope. the code will help you!

do you need in c#.net (windows application) or asp.net & c#.net (web application)

www.c-sharpcorner.com/UploadFile/718fc8/how-to-bind-bindingnavigator-with-datagridview I Hope the above url will help you!

How to dial and receive a call using asp.net

Regex.Replace("<!--myproductsku-->","<!--\s+-->","")

how was you tried?

for Oledb: OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"\\DBData1.mdb"); for SqlServer Database File: SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\Db_data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); before using this above code in C#.net make sure your database file is present in same of EXE's folder. ex: bin\Debug\myApp23.exe bin\Debug\Db_data.mdf bin\Debug\Db_data_log.ldf bin\Debug\DBData1.mdb

con.Open(); cmd = new OleDbCommand("INSERT INTO Product ([Item ID], [Item Name], [Item Type], [Quantity], [Min Shelf Stock], [Purchase Price], [Note]) VALUES (@Item_ID, @Item_Name, @Item_Type, @Quantity, @Min_Shelf_Stock, @Purchase_Price, @Note)",con) cmd.Parameters.Add("@Item_ID",OleDbType.Numeric).Value= txtItemID.Text cmd.Parameters.Add("@Item_Name",OleDbType.VarChar).Value= txtItemName.Text cmd.Parameters.Add("@Item_Type",OleDbType.VarChar).Value= cboItemType.Text cmd.Parameters.Add("@Quantity",OleDbType.Numeric).Value= txtQuantity.Text cmd.Parameters.Add("@Min_Shelf_Stock",OleDbType.Numeric).Value= txtMinShelfStock.Text cmd.Parameters.Add("@Purchase_Price",OleDbType.Currency).Value= txtPurchasePrice.Text cmd.Parameters.Add("@Note",OleDbType.VarChar).Value= txtNote.Text cmd.ExecuteNonQuery() con.Close() I Hope, the above code will …

public bool TestAlgorithm(string Data) { String[] vWords = System.IO.File.ReadAllLines(Application.StartupPath + "\\VulnerableWords.txt"); foreach (string vulrenableWord in vWords) { if (Data.Contains(vulrenableWord) && !String.IsNullOrEmpty(vulrenableWord.Trim()) ) return true; } return false; } bool Block=TestAlgorithm(txtWhatsOnYourHeart.Text); a = txtWhatsOnYourHeart.Text; if (!Block) { if (con.State == ConnectionState.Open) con.Close(); string PostDate = DateTime.Now.ToLongDateString(); con.Open(); string InsertPostquery = "Insert …

you created the sql database file also in same table design as like Access's table?

how was you tried?

Public Class Form4 Dim dt As New DataTable Private Sub Form4_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load dt.Columns.Add("Value") End Sub Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click dt.Rows.Add(Form3.TextBox1.Text) DataGridView1.DataSource = dt End Sub End Class Hope the above code will help u.!

Dim startPosX As Integer Dim startPosY As Integer = 0 Dim labelWidth As Integer = 0 Dim labelHeight As Integer = 0 Dim gapToLeave As Integer = 0 startPosX = 12 startPosY = 250 labelWidth = 110 labelHeight = 110 Try like this.!

what is your expected output?

Datareader needs an opened database connection. Its an Connected Oriented Architecture example Private Sub loop_QTY() Dim sql As String = "SELECT Item_Qty from tbl_Products WHERE Item_Name = '" & cbo_Items.Text & "' " Dim cmd As New OleDbCommand(sql, con) Dim dr As OleDbDataReader cbo_QTY.Items.Clear() con.Open() dr = cmd.ExecuteReader() While dr.Read() …

Private Sub loop_QTY() Dim sql As String = "SELECT Item_Qty from tbl_Products WHERE Item_Name = '" & cbo_Items.Text & "' " Dim cmd As New OleDbCommand(sql, con) Dim dr As OleDbDataReader cbo_QTY.Items.Clear() con.Open() dr = cmd.ExecuteReader() While dr.Read() cbo_QTY.Items.Add(dr(0)) End While con.Close() End Sub Hope the above code will help …

Could you please confirm the Table1's fields are in the non numeric data types? Dim command As New OleDbCommand("UPDATE Table1 SET Hb = '" & Hb & "',TC = '" & TC & "',DC = '" & DC & "' WHERE ID = " & Cint(ID) & "", Connection1)

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\IFMComac\\Documents\\Visual Studio 2013\\ifm.mdb.accdb"); OleDbCommand cmd = new OleDbCommand("INSERT INTO tblCheck (CheckID,Vehicle,Driver,Date,FuelLevel,WindscreenWasher,SteeringWheel,Brakes,Clutch,Horn,Heater,SeatBelts,WarningLights,Mirrors,[Tires/Wheels],Exhaust,[Lights/Reflectors],ExteriorLeaks,Body,OilLevel,CoolantLevel,Belts,EngineLeaks,[LooseBolts/Screws],WarningTriangle,[FireExtinguishers/FirstAidKit],Defects,AdditionalComments,CFirstName,CLastName) VALUES (@CheckID,@Vehicle,@Driver,@Date,@FuelLevel,@WindscreenWasher,@SteeringWheel,@Brakes,@Clutch,@Horn,@Heater,@SeatBelts,@WarningLights,@Mirrors,@Tires_Wheels,@Exhaust,@Lights_Reflectors,@ExteriorLeaks,@Body,@OilLevel,@CoolantLevel,@Belts,@EngineLeaks,@LooseBolts_Screws,@WarningTriangle,@FireExtinguishers_FirstAidKit,@Defects,@AdditionalComments,@CFirstName,@CLastName) ",conn); cmd.Parameters.Add("@CheckID", OleDbType.VarChar).Value = txtID.Text; cmd.Parameters.Add("@Vehicle", OleDbType.VarChar).Value = ddlReg.SelectedItem.Text; cmd.Parameters.Add("@Driver", OleDbType.VarChar).Value = ddlDrive.SelectedItem.Text; cmd.Parameters.Add("@Date", OleDbType.Date).Value = cldDate0.SelectedDate; cmd.Parameters.Add("@FuelLevel", OleDbType.VarChar).Value = cblFuel.SelectedItem.Text; cmd.Parameters.Add("@WindscreenWasher", OleDbType.VarChar).Value = cblWash.SelectedItem.Text; cmd.Parameters.Add("@SteeringWheel", OleDbType.VarChar).Value = cblWheel.SelectedItem.Text; cmd.Parameters.Add("@Brakes", OleDbType.VarChar).Value = …

'info: you can use column name as without spaces. 'For example 'use : projectnumber 'instead of [project number] 'in your database table and code also. it will help you sure

//if you want to show the data to gridview means? Try With cmd .Connection = con .CommandText = query End With Dim da As New SqlDataAdapter(query,con) Dim dt as DataTable da.Fill(dt) GridView1.DataSource=dt GridView1.DataBind()

cmd.CommandText = "INSERT INTO Clients(ClientName, Address, Town, County, PhoneNumber, MobileNumber, Username, [Password], EmailAddress) VALUES(@clientName, @address, @town, @county, @phone, @mobile, @username, @password, @email)" cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@clientName", txtClientName.Text); cmd.Parameters.AddWithValue("@address", txtAdd.Text); cmd.Parameters.AddWithValue("@town", txtTown.Text); cmd.Parameters.AddWithValue("@county", txtCounty.Text); cmd.Parameters.AddWithValue("@phone", txtPhone.Text); cmd.Parameters.AddWithValue("@mobile", txtMob.Text); cmd.Parameters.AddWithValue("@username", txtNewUser.Text); cmd.Parameters.AddWithValue("@password", txtNewPassword.Text); cmd.Parameters.AddWithValue("@email", txtNewEmail.Text); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); cmd.CommandText = "INSERT INTO …

cmd.CommandText = "INSERT INTO DailyWorkLoadRegister(ID,Age,FullName,Sex,Ward) " & "VALUES(" & Me.txtID.Text & ",'" & Me.txtAge.Text & "','" & Me.txtFullName.Text & "','" & Me.txtSex.Text & "','" & Me.txtWard.Text & "')" cmd.ExecuteNonQuery() //the above code confirms the fields Age,FullName,Sex,Ward are like varchar type.. //if age is numeric means //use: " & Cint(Me.txtAge.Text) & …

string[] str = { "I", "am", "too", "handsome" }; string t = str[1]; str[1] = str[0]; str[0] = t;

//adding all items from listbox1 to listbox2 foreach (string temp in listBox1.Items) listBox2.Items.Add(temp); //after you removed data, the below code will help you to regenarate the listbox1 listBox1.Items.Clear(); foreach (string temp in listBox2.Items) listBox1.Items.Add(temp);

if you try to add items in dropdownlist at page_load means , whenever the page loads the data will be added more time if true..use if(!Page.isPostback) { //To do for Adding items in dropdownlist box }

did u tried to run with *.msi in ur own system?

what is your expected output?

start form self close 1.create form with a timer 2.on form_load --> enable the timer 3.on timer_tick event make the code to hide current form and show next form. private void Form_Load(object sender,EventArgs e) { timer1.Interval=500; timer1.Enabled=true; } int i=0; private void timer1_tick(...) { i++; if(i>10) { timer1.Enabled=false; this.hide(); Form2 …

from DataBase-> to textfile? 1.Create a File (ex: *.txt) 2.Fill DataTable object from Database using select command 3.using foreach the each row from that dataTableObject's data will append to a single string 4.append the string with already created *.txt file System.IO.File.WriteAllText(@"c:\1.txt",""); DataTable dt=new DataTable(); SqlDataAdapter da = new SqlDataAdapter("select * …

Random rObj =new Random(); int n= rObj.next(10);