- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
14 Posted Topics
can u explain further? we cannot understand what you're going to achieve..
can anyone tell me how to use if else statement using c# and MS Access database..this is my code.. [CODE] protected void Button2_Click(object sender, EventArgs e) { string path = Server.MapPath("App_Data\\dnis2010.mdb"); OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path); //con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\keOn_kAyFar\\Documents\\Visual Studio 2008\\WebSites\\DNIS\\App_Data\\dnis2010.mdb;Persist Security Info=False"; conn.Open(); string str …
i'm using C# and database MS Access..i want to do a search by using dropdownlist and view in gridview..can anyone tell me or suggest me any link that can solve my problem..
can anyone tell me how to generate a chart using asp.net C# from database MS Access..which we do something like in Excel..
i'm using C# and MS Access database..i want to search name or serial no using LIKE statement..but i don't know how to do it..and then after i search it will view the match that i search for..let's say i want to search a letter start with 'C', an then it …
i've a problem here where when i logout i still can click back..can anyone solve my problem?
can u share u code here?
Is there anyone know how to use LIKE statement?
can anyone tell me what code should i use to print when i click the button it'll automatically print the page? or any other suggestion?
can anyone tell me how to publish web application from asp.net?
[CODE]protected void Button1_Click1(object sender, EventArgs e) { String path = Server.MapPath("App_Data\\dnis2010.mdb"); String sqlQuery = "UPDATE tableRegister SET (SerialNo,StaffName,StaffID,[Hostname],[Department],[Section],[Extension],Type,IpAddType,IpAdd,MacAdd,CpuBrand,CpuModel,Processor,HardDisk,HDType,RAM,RAMType,MonBrand,MonModel,MonSerialNo,MouBrand,MouModel,MouSerialNo,KeybBrand,KeybModel,KeybSerialNo,CdPlay,CdPlayBrand,CdPlayModel,CdPlayType,Windows,Other,WProdKey,MS,MSProdKey,SoftwareName,LicenceNo,Remarks) VALUES (@TextBox42,@TextBox1,@TextBox2,@TextBox3,@TextBox4,@TextBox5,@TextBox6,@TextBox40,@TextBox8,@TextBox9,@TextBox10,@TextBox11,@TextBox12,@TextBox13,@TextBox14,@TextBox15,@TextBox16,@TextBox17,@TextBox18,@TextBox19,@TextBox20,@TextBox21,@TextBox22,@TextBox23,@TextBox24,@TextBox25,@TextBox26,@TextBox27,@TextBox28,@TextBox29,@TextBox31,@TextBox32,@TextBox33,@TextBox34,@TextBox35,@TextBox36,@TextBox37,@TextBox38,@TextBox39) WHERE SerialNo=@TextBox41"; OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + path); OleDbCommand aCommand = new OleDbCommand(sqlQuery, aConnection); aCommand.Parameters.AddWithValue("TextBox42", TextBox42.Text); aCommand.Parameters.AddWithValue("TextBox1", TextBox1.Text); aCommand.Parameters.AddWithValue("TextBox2", TextBox2.Text); aCommand.Parameters.AddWithValue("TextBox3", TextBox3.Text); aCommand.Parameters.AddWithValue("TextBox4", TextBox4.Text); aCommand.Parameters.AddWithValue("TextBox5", TextBox5.Text); aCommand.Parameters.AddWithValue("TextBox6", …
[CODE]protected void Button3_Click(object sender, EventArgs e) { String path = Server.MapPath("App_Data\\dnis2010.mdb"); String sqlQuery = "SELECT * FROM tableRegister WHERE SerialNo=@TextBox41"; OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + path); OleDbCommand aCommand = new OleDbCommand(sqlQuery, aConnection); aCommand.Parameters.AddWithValue("TextBox41", TextBox41.Text); try { aConnection.Open(); OleDbDataReader aReader = aCommand.ExecuteReader(); if (!aReader.HasRows) { ClientScript.RegisterStartupScript(typeof(Page), "PopUpMsg", "<script>alert …
how to insert radiobutton value into Access database using c#? rely need help...
[CODE]using System; using System.Configuration; using System.Data; using System.Data.OleDb; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public partial class Add : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { String path = Server.MapPath("App_Data\\dnis2010.mdb"); …
The End.
kayfar