Hi, I have CLR procedure which sends request to server and get the url, I need to open that url into browser. I am trying to do it in the application code by Process.Start("IExplore.exe",url). When I debug the code it runs fine but when it deploy to SQL Server to call from CLR procedure it returns error "Request Failed". Hope someone can help to solve this. Thanks

@OriginalGriff: Dont be jealous. Also show the previous posts... The thing is you don't know the answer and I am done with my task.

If I have to test it through batch file then how I will pass the arguments and also invoke the .Exe file, can you provide a sample?

Hi, I have console based application which send request by using httpwebrequest method and save the response in XML file. I need to accept parameters from other application which is not in .Net. Is it possible to build batch file that accept arguments from other application and then pass it to .Net console based application? Thanks, Shahzad

I am trying to copy one dataset to another and calling acceptchanges to update database but it is not working although not giving any error. here is the code. SqlDataAdapter da2 = new SqlDataAdapter("SELECT * FROM " + DestinationTableName, consql); DataSet dsDest = new DataSet(); dsDest.CaseSensitive = false; da2.Fill(dsDest, DestinationTableName); dsDest.Tables[0].TableName = DestinationTableName; DataTable dt = new DataTable(); dt.TableName = DestinationTableName; foreach (DataRow dr in dsSource.Tables[0].Rows) { DataRow drdata= dsDest.Tables[0].NewRow(); foreach (DataColumn dc in dsSource.Tables[0].Columns) { drdata[dc.ColumnName] = dr[dc.ColumnName]; } dsDest.Tables[0].Rows.Add(drdata); dsDest.AcceptChanges(); da2.Update(dsDest.Tables[0]); } Whats wrong with above code..?

Thanks, I did it using modifying custom errors in IIS and edit 404 error, provide absulute URL. http://www.nerdymusings.com/LPMArticle.asp?ID=12[^]

Hi All, Can I write HTTP Handler for the folder which does not exist? for example if I write "http:/localhost/website/CompanyName" it should be redirected to the specific page.

Thanks, Shahzad Aslam

I have read the file using StreamReader it has given some info about file. File is encoded with UTF-8 with code page 65001. It shows \n as line terminator which is not work with SQL bulk Insert.

Shahzad Aslam Software Engineer Email: shehzadaslam@hotmail.com

I have tested this too, still not working.

Shahzad Aslam Software Engineer Email: shehzadaslam@hotmail.com

Hi, I am using sql bulk copy to insert into table from txt file. The following code is is being used for row terminator but it does not work. it works with '\n'. But it should be work with Unix system as well. @BQUERY AS nVARCHAR(250) SET @BQUERY = 'BULK INSERT tblCustomer FROM ''' + @FILEPATH + ''' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '','', ROWTERMINATOR = ''\x0A'' )' EXECUTE SP_EXECUTESQL @BQUERY

Shahzad Aslam Software Engineer Email: shehzadaslam@hotmail.com

yes 10 characters needed and then need to parse them, it could be a sensible format in the future but currently we have to continue with this..

Shahzad Aslam Software Engineer Softech Systems Limited Email: shehzadaslam@hotmail.com

Hi Friends, I am having problem with extracting data from a field which has datatype text in sql server 2005. Following is the two sample rows which contains the field. 1. TrackID14910417OrderID1019RefReason1019Src21244700309600019SID13640214PayCh13MJA210PurchaseID10218 2. TrackID145493211Description235USE+IT+UP+AND+WEAR+IT+OUT+-+ODYSSEY17OrderID10210PurchaseID1019RefReason10214PayCh13MJA16UserID23642B942B8-05D0-4447-BEEC-7EF11419368B217CVFDate1019SID13640213TID1019Dst21244700059600 I want to extract TrackID value from above two rows, the length of the values may vary, it might be 8,9 or 10 digits long.

Shahzad Aslam Software Engineer Softech Systems Limited Email: shehzadaslam@hotmail.com

This was not the one that I was expecting. The appsettings section can be read easily but my concern was to read ConfigSections group which we used for our customized section. Shahzad Aslam Software Engineer Softech Systems Limited Email: shehzadaslam@hotmail.com

Hi I am having problem with reading configSections from web.config file. Can anyone provide a sample code, how to read this group. Following in the web.config: I am trying following code to read but the object a contains null value. NameValueCollection a = (NameValueCollection)ConfigurationSettings.GetConfig("merchants"); Shahzad Aslam Software Engineer modified on Wednesday, February 13, 2008 12:38 AM

This is still not working and giving the following error: Cannot perform '=' operation on System.Int32 and System.String.

Shahzad Aslam Software Engineer

Hi I want to count the rows in a DataTable but it should ignore blank rows, I am trying something this, string batchid = ds.Tables["No"].Columns[0].ColumnName; ds.Tables[0].DefaultView.RowFilter = "" + batchid.Trim() + "=" + string.EmptyString; int records=ds.Tables[0].Rows.counl; the above code showing me following error. Syntax error: Missing operand after '=' operator

Shahzad Aslam Software Engineer Email: shehzadaslam@hotmail.com

Hi I am trying to convert an integer value to time is it possible in a query to convert? For example a value 130210 stored as int should display as hh:mm:ss format.

Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com

Thanx!!!

Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com

Hi I have month and year values, I want to get last day of month. How it can be acheived in SQL server 2005?

Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com

Hi I want to select records from last two days, the following query does not return any record. select * from tablename where datefield = dateadd(day,-2,Getdate()) Any help will be appreciated.

Shahzad Aslam Software Engineer