Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
0 Endorsements
Ranked #4K
~3K People Reached

14 Posted Topics

Member Avatar for srvstv.prnc
Member Avatar for srvstv.prnc
0
162
Member Avatar for kayfar

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 …

Member Avatar for crishjeny
0
330
Member Avatar for kayfar

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..

Member Avatar for bondeth
0
109
Member Avatar for kayfar

can anyone tell me how to generate a chart using asp.net C# from database MS Access..which we do something like in Excel..

Member Avatar for jbisono
0
57
Member Avatar for kayfar

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 …

Member Avatar for kayfar
0
168
Member Avatar for kayfar

i've a problem here where when i logout i still can click back..can anyone solve my problem?

Member Avatar for kayfar
-1
202
Member Avatar for neetika reddy
Member Avatar for kayfar
Member Avatar for kayfar

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?

Member Avatar for patelriki13
0
99
Member Avatar for kayfar
Member Avatar for kayfar
0
78
Member Avatar for kayfar

[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", …

Member Avatar for kayfar
0
324
Member Avatar for kayfar

[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 …

Member Avatar for Lusiphur
0
480
Member Avatar for kayfar
Member Avatar for Lusiphur
0
124
Member Avatar for kayfar

[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"); …

Member Avatar for Lusiphur
0
100

The End.