i m using ASP.NET with C# (.net 2005, 2.0 framework) i m more interest to read and practice WEB SERVICE concepts and willing to create simple GUI applications... where can i find these things? i searched in google.but the HELLO WORLD example only coming........ help me

for (i=1;i=5;i++) { int a=i; sqlinsert="update tbl_name set loop_no=a where rollnumber=a"; cmd = new SqlCommand(sqlinsert, conn); try { cmd.ExecuteNonQuery(); } catch(Exception ex) { FileStream fs; StreamWriter sw; fs=new Filestream("logfile.txt",FileMode.open); sw=new StreamWriter(fs); string newline="Roll No:"+a+"was not updated"; sw.close(); fs.close(); } } once if its go for "CATCH" block, how it can proceed others? i.e, if record 2 fails, will it proceed other records and complete the whole FOR loop???? i tried.. but getting error... how to achieve it? thanks in advance and understanding....

once if its go for "CATCH" block, how it can proceed others? i.e, if record 2 fails, will it proceed other records and complete the whole FOR loop???? i tried.. but getting error... how to achieve it? thanks in advance and understanding....

hai, here i am updating 100 records at the same time. when the update fails, the record is to store in a log file (.txt). how to implement.? FOR EXAMPLE............. try { for (i=1;i=5;i++) { int a=i; sqlinsert="update tbl_name set loop_no=a where rollnumber=a"; cmd = new SqlCommand(sqlinsert, conn); } } catch(SqlException ae) { strreturn += "<br>Message: " + ae.Message.ToString(); } How to capture the failure records for the above UPDATE statement? HELP ME! i m using ASP.NET with C# (.net 2005, 2.0 framework)

no senthil, i m taking those roll numbers from an excel file and processing.... i will pass the roll number one by one. when it failed, i want to store it........ how to achieve it?

try { cmd.ExecuteNonQuery(); } catch(Exception ex) { FileStream fs; StreamWriter sw; fs = new FileStream("practice.txt", FileMode.Open ); sw = new StreamWriter(fs); // write a line to the file //In this line you concatenate the data string newLine = "Not so different from you and me"; sw.WriteLine(newLine); // close the streams sw.Close(); fs.Close(); } -----> i dont want to store a single line in the practice.txt. i need to store the record values which is failed (i.e.. 100,200) as mentioned in my example....... How to achieve it? thanks in advance

could u provide me an example senthil? for my QUESTION?

hai, here i am updating 100 records at the same time. when the update fails, the record is to store in a log file (.txt). how to implement.? FOR EXAMPLE............. try { for (i=1;i=5;i++) { int a=i; sqlinsert="update tbl_name set loop_no=a where rollnumber=a"; cmd = new SqlCommand(sqlinsert, conn); } } catch(SqlException ae) { strreturn += "<br>Message: " + ae.Message.ToString(); } How to capture the failure records for the above UPDATE statement? HELP ME! i m using ASP.NET with C# (.net 2005, 2.0 framework)

modified on Wednesday, April 16, 2008 8:40 AM

I found the answer in query itself sandeep... just refer it SELECT REPLACE(CONVERT(VARCHAR, column_name, 106), ' ', '-') as "column 1" from tbl_name :) Take care...

Thanks a lot sandeep... nice to meet you......... :-O

can u tel me with the example sandeep?? plz.. suppose my full path is : c:\inetpub\wwwroot\project\tet_pr.ascx another file path is : c:\inetpub\wwwroot\project\output\file1.ascx how to switch from "file1" to "tet_pr" while i m working in "file1.ascx" int a; if (a == 1) this.MenuPlaceHolder.Controls.Add((UserControl)LoadControl("te_pr.ascx")); else this.MenuPlaceHolder.Controls.Add((UserControl)LoadControl("file1.ascx")); help me . thanks for understanding......... - KARAN

Thanks sandeep.. to fetch the te_pr.ascx from file1.ascx??????????? how to achieve it?

wow...... S sandeep.. i got it.. this is i needed. :-D and another clarification sandeep? suppose my full path is : c:\inetpub\wwwroot\project\tet_pr.ascx another file path is : c:\inetpub\wwwroot\project\output\file1.ascx how to switch from one file to another by using the below statement? int a; if (a == 1) this.MenuPlaceHolder.Controls.Add((UserControl)LoadControl("te_pr.ascx")); else this.MenuPlaceHolder.Controls.Add((UserControl)LoadControl("file1.ascx")); help me . thanks for understanding......... - KARAN

Thanks a lot sandeep... i achieved 90% of my requirement. but i cant get the separator (any separator is OKAY) the output is "25 Jan 2007". my requirement is "25-Jan-2007". is there anyway to achieve it?, so that my requirement will get fulfilled 100% :)

modified on Saturday, April 12, 2008 3:12 AM

kindly could u give me an example, so that i can understand clearly. And also can u specify by means of the example which i have posted?. thank you...

Thanks sandeep kumar.V but the thing i need is "DD-MMM-YYYY" (this exact format). and also i need the alias name also... my exact query..... select convert(varchar,column1 as "Test column",106) from tbl_name how to achieve it?????

hai, i m using ASP.NET with C# (.net 2005, 2.0 framework) here i have a datagrid which contains 10 columns. the 4,5,8 column contains date in the format (7/23/2007 12:00:00 AM). i want to change those date in (23-Jul-2007). the major key point in this is.... 1. Fields are dynamic, so i cant fix in DATABOUNDCOLUMN 2. The placement should be the same (i.e, 4,5,8 columns) 3. The data are filled to datagrid from SQL Server. How to achieve it? help me...... - KARAN

hai, i m using ASP.NET with C# (.net 2005, 2.0 framework) here i create a directory named "A" and some files are in this folder (say... A1,A2). and outside of "A" folder there are some files (out1,out2). how can i specify the path to fetch the file from A1 to out1??? how to achieve it? help me - KARAN

[Message Deleted]

is this a free one? full version?