ASP.NET

FirstPrevNext

Re: resize the iframe Vasudevan Deepak Kumar1-Oct-09 1:20 Vasudevan Deepak Kumar 1-Oct-09 1:20  d'kng wrote: asp.net You would rather use a JavaScript for that. Vasudevan Deepak Kumar Personal Homepage Tech Gossips The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep! Global variable in c# JaganBR30-Sep-09 23:54 JaganBR 30-Sep-09 23:54  I have 2 classes in a code behind file. one for events of the webpage and another class for custom repeater control. I create an array in the page load event. During the execution when the control enters into custom repeater control class the array I created in the page load event is lost. how to retain that array so that I can access it from both the classes Re: Global variable in c# Paramhans Dubey1-Oct-09 0:02 Paramhans Dubey 1-Oct-09 0:02  declare the array as static array. how can u insert values in the database sumanmks30-Sep-09 23:53 sumanmks 30-Sep-09 23:53  hi i am very new to asp.net. It may be the simplest problem to u. but for me it is a bit difficult. I have written a code for inserting the values in the SQLEXPRESS in C#.but not able to insert it. Can Any one help me out. the code is as follows: protected void Button1_Click1(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = @"Data Source=localhost\SQLEXPRESS;" + "Initial Catalog=testdata;Integrated Security=SSPI"; try { myConnection.Open(); Label1.Text = "<b>Server Version:</b> " + myConnection.ServerVersion; Label1.Text += "<br /><b>Connection Is:</b> " + myConnection.State.ToString(); string insertSQL; insertSQL = "INSERT INTO jobseekerinfo ("; insertSQL += "firstname, middlename, lastname, "; insertSQL += "dob, address, city, state, zip, mobile, phone, engcollege, "; insertSQL += "enguniversity, engaggergate, pucollege, puuniversity, pumarks,"; insertSQL += "school, scuniversity, scmarks, totalyears, totalmonths,"; insertSQL += "workplace, job, skills"; insertSQL += "VALUES ('"; insertSQL += TextBox1.Text + "', '"; insertSQL += TextBox2.Text + "', '"; insertSQL += TextBox3.Text + "', '"; insertSQL += TextBox29.Text + "', '"; insertSQL += TextBox5.Text + "', '"; insertSQL += TextBox11.Text + "', '"; insertSQL += TextBox12.Text + "', '"; insertSQL += TextBox14.Text + "', '"; insertSQL += TextBox6.Text + "', '"; insertSQL += TextBox15.Text + "', '"; insertSQL += TextBox4.Text + "', '"; insertSQL += TextBox8.Text + "', '"; insertSQL += TextBox9.Text + "', '"; insertSQL += TextBox10.Text + "', '"; insertSQL += TextBox30.Text + "', '"; insertSQL += TextBox31.Text + "', '"; insertSQL += TextBox32.Text + "', '"; insertSQL += TextBox33.Text + "', '"; insertSQL += TextBox34.Text + "', '"; insertSQL += TextBox35.Text + "', '"; insertSQL += TextBox36.Text + "', '"; insertSQL += TextBox18.Text + "', '"; insertSQL += TextBox19.Text + "', '"; insertSQL += TextBox20.Text + "', '"; insertSQL += "')"; SqlCommand cmd = new SqlCommand(insertSQL, myConnection); int added = 0; added = cmd.ExecuteNonQuery(); Label1.Text = added.ToString() + " records inserted."; } finally { myConnection.Close(); Label1.Text += "<br /><b>Connection Is:</b> " + myConnection.State.ToString(); } } Thanks in advance Re: how can u insert values in the database J4amieC30-Sep-09 23:59 J4amieC 30-Sep-09 23:59  sumanmks wrote: but not able to insert it We're not mindreaders you know. What error do you get? Re: how can u insert values in the database Abhijit Jana1-Oct-09 0:04 Abhijit Jana 1-Oct-09 0:04  It was a cross post and both we have missed it !! Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET Re: how can u insert values in the database sumanmks1-Oct-09 0:08 sumanmks 1-Oct-09 0:08  hello sir, there is no syntax errors Re: how can u insert values in the database Abhijit Jana30-Sep-09 23:59 Abhijit Jana 30-Sep-09 23:59  AS you are very new with this and your code is also saying like that. I would suggest you to read this article first, Using ADO.NET for beginners[^] Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET Re: how can u insert values in the database Abhishek Sur1-Oct-09 0:07 Abhishek Sur 1-Oct-09 0:07  sumanmks wrote: insertSQL += "workplace, job, skills"; where is the end bracket of fields ??? It should be "workplace, job, skills)"; Abhishek Sur My Latest Articles Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB Don't forget to click "Good Answer" if you like to. Re: how can u insert values in the database sumanmks1-Oct-09 0:12 sumanmks 1-Oct-09 0:12  hi sir, Can i know y there will be a pop up message when i run the project saying that Visual Studio just in-time debugger Re: how can u insert values in the database Abhishek Sur1-Oct-09 0:15 Abhishek Sur 1-Oct-09 0:15  In the browser? or in your debug environment ? Also can you show the exact message, may be a snap. This would help me what exactly the error might be. Sometimes if IE script debugging is disabled, it VS prompts an error message... I guess if it is your case.. Abhishek Sur My Latest Articles Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB Don't forget to click "Good Answer" if you like to. Re: how can u insert values in the database sumanmks1-Oct-09 0:53 sumanmks 1-Oct-09 0:53  hi abhishek IE script debugging is disabled is my problem can u please tell me how to get rid of this problem. Re: how can u insert values in the database Greg Chelstowski1-Oct-09 0:15 Greg Chelstowski 1-Oct-09 0:15  I see the thread switched locations, but still blossoms... Let's wait till it moves again, because I think all the information provided to that guy is totally irrelevant to him. var question = (_2b || !(_2b)); Re: how can u insert values in the database Abhishek Sur1-Oct-09 0:30 Abhishek Sur 1-Oct-09 0:30  Really.. Its a cross post again. Abhishek Sur My Latest Articles Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB Don't forget to click "Good Answer" if you like to. Re: how can u insert values in the database Vasudevan Deepak Kumar1-Oct-09 1:22 Vasudevan Deepak Kumar 1-Oct-09 1:22  Two points: 1) You would need to explicitly tell what is the error you are encountering. 2) Your code is highly vulnerable to SQL Injection attacks. You may need to address that first in case you are interested in the safety of your application seriously. Vasudevan Deepak Kumar Personal Homepage Tech Gossips The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep! Re: how can u insert values in the database hemant.kaushal2-Oct-09 2:52 hemant.kaushal 2-Oct-09 2:52  insertSQL += "workplace, job, skills"; insertSQL += "VALUES ('"; output of above line will be workplace, job, skillsValues (' so it will give syntax error when executed on database change your code to insertSQL += " workplace, job, skills "; insertSQL += " VALUES('"; always remember to add proper spaces between keywords when u are createng query through code. The request failed with HTTP status 401: Unauthorized. Calla30-Sep-09 23:48 Calla 30-Sep-09 23:48  I'm having trouble with a website when it comes to the authorization. I have one site, called GUI, using a webservice, called WS that requires the user to log on using windows autentication. In the IIS I have set the Directory Security to Integrated windows security (for both the GUI and the WS sites). In my web.config files (for the GUI and the WS) I have the following lines: <authentication mode="Windows"/> <identity impersonate="true"/> When I enter the URL in IE I get prompted for User name and Password, and I'm sure I enter the correct ones but I still get the The request failed with HTTP status 401: Unauthorized. message. I am running the same web sites on another machine where I use the Enable anonumous access in the IIS and this (of course) works fine. Does anyone have any idea of what might be the issue here? Url rewrite Ramkumar_S30-Sep-09 23:38 Ramkumar_S 30-Sep-09 23:38  Hi All i am using Intelligencia.UrlRewriter.dll for Url rewriting.. In web.config this works fine <rewriter> <rewrite url="~/products.aspx/books" to="~/products/books.aspx"> http://localhost:3878/products.aspx/books My problem is ------------------- <rewriter> <rewrite url="~/products/books" to="~/products/books.aspx"> http://localhost:3878/products/books This type is working in my local server but when i upload in FTP it is not working http://www.cminfoline.cmlinks.com/products/books---not working My requirement ----------------- Actual URL : http://localhost/UrlRewrite/show.aspx?Year=2008 URL Should Look Like : http://localhost/UrlRewrite/2008/ Please help me with this.... Thanks in Advance Ramkumar Re: Url rewrite Abhishek Sur30-Sep-09 23:45 Abhishek Sur 30-Sep-09 23:45  getramonweb wrote: when i upload in FTP AFAIK, IIS 6 doesnt support requests without extensions. So any request made without extension, will not be handled properly. Use an extension and register it with IIS. Abhishek Sur My Latest Articles Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB Don't forget to click "Good Answer" if you like to. Re: Url rewrite Ramkumar_S30-Sep-09 23:57 Ramkumar_S 30-Sep-09 23:57  Thanks (it was great help for us).. Is it possible to do without extension...because you know http://www.dotnetkicks.com/wpf was developed using this.. Ramkumar Re: Url rewrite Abhishek Sur1-Oct-09 0:02 Abhishek Sur 1-Oct-09 0:02  Yes.. I think IIS 7 supports url without extension. I dont know if there is any fix for this in IIS 6, as MVC does this as well. Abhishek Sur My Latest Articles Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB Don't forget to click "Good Answer" if you like to. Re: Url rewrite Ramkumar_S1-Oct-09 0:16 Ramkumar_S 1-Oct-09 0:16  Thanks ..Let me check with this...bye Ramkumar Alignment proble in firefox benams30-Sep-09 23:37 benams 30-Sep-09 23:37  I have a table, some menus and images aligned to the center. When I go to my site with explorer it usually looks great, but in firefox it's not aligned(the problem also occurs in some explorer versions). my site : http://eturim.co.il/he/default.aspx?page=home[^] do you have any solution? Re: Alignment proble in firefox S.Dhanasekaran1-Oct-09 3:06 S.Dhanasekaran 1-Oct-09 3:06  Hi... In IE browser take a width in pixels as default. But in Mozilla u must set in Percentage(%) only. Ex: style="width:30%" not able to insert the values sumanmks30-Sep-09 23:35 sumanmks 30-Sep-09 23:35  hi i am very new to asp.net. It may be the simplest problem to u. but for me it is a bit difficult. I have written a code for inserting the values in the SQLEXPRESS in C#.but not able to insert it. Can Any one help me out. the code is as follows: protected void Button1_Click1(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = @"Data Source=localhost\SQLEXPRESS;" + "Initial Catalog=testdata;Integrated Security=SSPI"; try { myConnection.Open(); Label1.Text = "<b>Server Version:</b> " + myConnection.ServerVersion; Label1.Text += "<br /><b>Connection Is:</b> " + myConnection.State.ToString(); string insertSQL; insertSQL = "INSERT INTO jobseekerinfo ("; insertSQL += "firstname, middlename, lastname, "; insertSQL += "dob, address, city, state, zip, mobile, phone, engcollege, "; insertSQL += "enguniversity, engaggergate, pucollege, puuniversity, pumarks,"; insertSQL += "school, scuniversity, scmarks, totalyears, totalmonths,"; insertSQL += "workplace, job, skills"; insertSQL += "VALUES ('"; insertSQL += TextBox1.Text + "', '"; insertSQL += TextBox2.Text + "', '"; insertSQL += TextBox3.Text + "', '"; insertSQL += TextBox29.Text + "', '"; insertSQL += TextBox5.Text + "', '"; insertSQL += TextBox11.Text + "', '"; insertSQL += TextBox12.Text + "', '"; insertSQL += TextBox14.Text + "', '"; insertSQL += TextBox6.Text + "', '"; insertSQL += TextBox15.Text + "', '"; insertSQL += TextBox4.Text + "', '"; insertSQL += TextBox8.Text + "', '"; insertSQL += TextBox9.Text + "', '"; insertSQL += TextBox10.Text + "', '"; insertSQL += TextBox30.Text + "', '"; insertSQL += TextBox31.Text + "', '"; insertSQL += TextBox32.Text + "', '"; insertSQL += TextBox33.Text + "', '"; insertSQL += TextBox34.Text + "', '"; insertSQL += TextBox35.Text + "', '"; insertSQL += TextBox36.Text + "', '"; insertSQL += TextBox18.Text + "', '"; insertSQL += TextBox19.Text + "', '"; insertSQL += TextBox20.Text + "', '"; insertSQL += "')"; SqlCommand cmd = new SqlCommand(insertSQL, myConnection); int added = 0; added = cmd.ExecuteNonQuery(); Label1.Text = added.ToString() + " records inserted."; } finally { myConnection.Close(); Label1.Text += "<br /><b>Connection Is:</b> " + myConnection.State.ToString(); } } Thanks in advance

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 6:05 Refresh ᐊ Prev1...1459146014611462146314641465146614671468 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.