karthikc85

hi everybody,i have created a webform with a button to read bulk data from a .CSV file from a path :C:\karfiles\myfile.csviam using a bulk insert command to insert all records into database in VS 2005 WINDOW APPLICATION C# USING SQL SERVER 2005.when i click the button iam getting this exception :"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dllAdditional information: Could not bulk insert because file 'C:\karfiles\myfile.csv' could not be opened. Operating system error code 3(The system cannot find the path specified.)." at cmd.executenonquery.i want to trouble shoot this exception .please can anybody help me?thanks,karthik.

HI ASPNETGUY,CAN YOU SUGGEST ANY OTHER ALTERNATIVE FOR THE PROBLEM?CAN YOU TELL ME HOW TO STORE THOSE TEXTBOX VALUES IN ANY OTHER WAY?I HAVE BROWSED MANY SITES ALL OF THEM ARE ADVICING TO RECREATE THE USER CONTROL AGAIN??BUT IAM NOT ABLE TO UNDERSTAND WHAT THEY MEAN?PLEASE REPLY.THANKS,KARTHIK.

hi aspnetguy,thanks for your response.heres my code:i write THIS in a button click to just show a datagrid for 2 questions and also TO DISPLAY THE USERCONTROL WITH 2 TEXTBOXES AND A BUTTON INSIDE IT TO READ THOSE 2 ANSWERS.IN .ASCX FILE OF THE USER CONTROL I HAVE CREATED 2 SESSION STATES TO STORE THE ANSWERS FROM THE 2 TEXTBOXES.WHEN I CLICK THE BUTTON IN USERCONTROL THE WHOLE USERCONTROL JUST GOES OFF AND SESSION STATES ARE GETTING EXPIRED.in button click: Control question1 = Page.LoadControl(@"~/question1.ascx"); Panel1.Controls.Add(question1);String connectionString = @"Data Source=DT-CORP-IT-8;Initial Catalog=employee;User ID=sa;Password=sa"; String queryString = "SELECT qid,qdescr FROM question"; DataSet ds = new DataSet(); SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection); adapter.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind();IN THE NEXT BUTTON CLICK I WANT TO STORE THE VALUES INTO DATABASE AS THIS:string x = (string)(Session["name"]); string y = (string)(Session["age"]); insert(x, y); String connectionString = @"Data Source=DT-CORP-IT-8;Initial Catalog=employee;User ID=sa;Password=sa"; String queryString = "SELECT * FROM answer"; DataSet ds = new DataSet(); SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection); adapter.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); insert function: string insert, source; source = @"Data Source=DT-CORP-IT-8;Initial Catalog=employee;User ID=sa;Password=sa"; insert = @"insert into answer values ('" + a + "')"; SqlConnection conn = new SqlConnection(source); conn.Open(); SqlCommand cmd = new SqlCommand(insert, conn); cmd.ExecuteNonQuery(); conn.Close();THIS IS MY PROBLEM PLEASE SOLVE IT.IF YOU WANT STILL ANYMORE CLARIFICATIONS YOU PLEASE ASK ME I WANT TO SOLVE THIS PROBLEM AT ANY COST.IAM READY TO CONVERSE WITH AS MANY TIMES AS POSSIBLE WITH YOU AND WANT TO CLARIFY MY DOUBT.THANKS IN ADVANCE.THANKS,KARTHIK.

hi everybody,iam facing a variety problem with asp.net(vs 2005) using c#.i have created a user control with 2 TEXTBOXES AND 1 BUTTON ON A PAGE.when i display the usercontrol STATICALLY iam able to read the values in the textboxes into session states and insert them into database. and also iam able to debug my control.ascx file also.when i display the usercontrol DYNAMICALLY iam NOT able to read the values in the textboxes into session states and CANNOT insert them into database. and also iam NOT able to debug my control.ascx file also.can anybody explain why is this happening?thanks,karthik.

hi,thanks for the reply.the url u have provided didnt help me much.will u please look into my problem once again?suggest me a good solution.thanks,karthik.

hi everybody,i have created a usercontrol with 2 TEXTBOXES and 1BUTTON.i was able to dynamically load it into my webpage.i have entered values into the 2 TEXTBOXES.my problem is that when user clicks an event the 2 TEXTBOX values must be inserted into database(sqlserver2005).for that i need to capture those 2 values into 2 variables.this has to be written in the code behind file.iam not able to get those 2 values in usercontrols textboxes into 2 variables.HOW CAN I GET THOSE 2 VALUES? iam using VS2005 AND C#.anybody please help me.thanks,karthik.

hi jesh,thanks a lot for ur reply.iam interested in buying 0rielly's javascript-the definitive guide 5th editiondo u refer this book for my reading?please reply me.thanks,karthik.

hi everybody,iam verymuch new to javascript.can anyone suggest me a good and detailed book on javascript that is to be essentially usefull to me in writing into asp.net 2.0 web pages.i need a latest javascripting book.any body please help me.thanks,karthik.

hi everybody,iam new to this xml.can anyone suggest me a good book to get a good knowledge on xml with asp.net 2.0thanks,karthik.

hi jesh,thanks for responding to my query.what u said is right iam able to validate all my textboxes using validatorson the webpage.but my doubt all real time programmers suggest me to go for writing your own javascript for validating the fields.does it improve the efficiency of the webpage or it depends on requirements.please reply me.thanks,karthik.

hi everybody,i need to validate a webpage with some textbox and button.compulsion is placed for user to write a text in textbox and if he clicks submit button with out text he must get an alert box.this should be done using javascript.in visualstudio 2005 (asp.net 2.0)assume that i have already placed an asp controls of textbox and button.any body please respond to me.thanks,karthik reddy chintaparthi.