<> wrote: cmd.Parameters.Add("@App_Authority", OdbcType.VarChar, 1200).Value = GetNull(App_Authority) Above is varchar, but in the table, you made it nvarchar, It's a mismatch, that involves unicode I think, in which one is double the space of the other, varchar is a 8bit codepage [edit] adjust your column in the table to take 1200 or whatever the value is suppose to be or vice versus App_Authority varchar(1200) NULL

Even when you send a plain text email, the email client could add the link! In such cases you could try to "hide" the fact that it is an email address, e.g. "test [at] email [dot] com"

I usually write the data to an XML file and attach it. The receiver can then use XSLT to transform the data to HTML, CSV, etc.

Hi.. Thanx for the reply.. well thats what i have done.. finally completed it with javascript.. but still im amazed why doesnt the logic takeplace at the text changed method of the textbox.:confused:. will investigate on it, finally have done the task. Thanx and regards, Tash..

Hi thanks for your reply. Actually i can display the path of the file in my page. since im using a repeater over here i wanna show the path of the file as a hyper link and when user clicks on the path the file should get downloaded.. im struggling at this point.. Any help is appreciated.. Thanx in advance, Tash

Thanx a million buddy.. works like a charm.... thanx alot...

Thank you so much....................... http://www.codeproject.com/Members/Mohammed-Hameed[^] Be a good professional who shares programming secrets with others.

<> wrote: string FrmDt=DtP_frm.Text.Replace("/",""); In here, before replacing the '/', convert into the yyyymmdd format that you need and then replace the '/', pass on as search parameter to Database. Like: String tempDate = Convert.ToDateTime(DtP_frm.Text).ToString("yyyy/MM/dd"); Now use this tempDate for your manipulation of removing the '/' and passing to DB.

On googling out i came to know that in web.config file we have to add the following tag: <system.web> <httpRuntime executionTimeout="5"/> I set it 5 which means 5 seconds but after 5 seconds the synchronisation process doesnt get time out which means the executiontimeout tag is not responsible for my problem... Im confused... plz advise... Thanx in advance.. Tash

There is no issue. Excel sees this as a number and will truncate the leading zeros by default. Change the formatting of the cells in the Excel spreadsheet. I know the language. I've read a book. - _Madmatt

Thanx a lot i found another solution for my issue.... actually i used the following code to solve it... i used String collection to store the value and checked it and printed the table accordingly ElseIf page = "UserApplication" Then If DS.Tables(0).Rows.Count > 0 Then InsertPageBreak() InsertAppUserHeader() Dim nfile As StringCollection = New StringCollection Session("sc1") = nfile For i = 0 To DS.Tables(0).Rows.Count - 1 PopulateAppUsrRow(DS.Tables(0).Rows(i)(0), DS.Tables(0).Rows(i)(1), DS.Tables(0).Rows(i)(2), DS.Tables(0).Rows(i)(3), DS.Tables(0).Rows(i)(4)) 'DataSetToExcel.Convert(DS, Response) Next Now the Html table gets populated by the following code: Public Sub PopulateAppUsrRow(ByVal Usrid As String, ByVal Usrname As String, ByVal Grpid As String, ByVal Grpdsc As String, ByVal FncDsc As String) If Not Session("sc1").Contains(Usrid) Then Session("sc1").Add(Usrid) Response.Write("<tr><td align=left>" + Usrid + "</td><td align=left >" + Usrname + "</td><td align=left >" + Grpid + "</td><td align=left >" + Grpdsc + "</td><td align=left >" + FncDsc + "</td></tr>") Else Response.Write("<tr><td align=left> </td><td align=left >" + Usrname + "</td><td align=left >" + Grpid + "</td><td align=left >" + Grpdsc + "</td><td align=left >" + FncDsc + "</td></tr>") End If End Sub Im happy with this kinda output.. any advice is appreciated... Thanx in advance... Tash

No problem. I also don't think it was particularly dumb compared to the general par.

Simply put, this construct tells the page that it should only do whatever is inside the 'if' should this be the first time the page has been loaded. Tychotics: take us back to the moon "Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars." H. G. Wells

http://aspalliance.com/1327\_Debugging\_DLL\_Projects\_in\_Visual\_Studio\_2005.all http://social.msdn.microsoft.com/forums/en-US/vsdebug/thread/c18ac6df-b5bd-4dd7-a043-de214b687247

What I actually meant was that when I tried I was not able to do so using VS 2005, it didn't happen. I was not trying to make a conclusive statement, but just sharing my opinion. So, there are all chances that your friend is correct. BTW, I forgot to add yesterday, If you try to execute 2 web application from the same instance of VS IDE it works. I've started debugging a web service and then stepped through a website that consumes the service from the same IDE without any problems. So, may be from the same instance of the IDE may be it is possible, from two instances of the same version of IDE may be it is not. Again this is not a conclusive statement, just clues to the puzzle. :)

use ... Response.ContentType = "text/xml"; Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml"); Response.TransmitFile(Server.MapPath("~/images/mmm.jpg")); SqlDataAdapter da = null; try { con = new SqlConnection(); con.ConnectionString = ConfigurationSettings.AppSettings["DSN"]; da = new SqlDataAdapter("select * from card_details", con); DataSet ds = new DataSet(); da.Fill(ds, "card_details"); ds.WriteXml(Response.OutputStream); Response.End(); } catch (SqlException ex) { throw new System.Exception("Error -- " + ex.Message); } catch (Exception exp) { throw new System.Exception("Error -- " + exp.Message); } finally { con.Close(); da.Dispose(); }

if (!string.IsNullOrEmpty(query)) { // premission granted } .45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

<> wrote: okay fine i will take up ur advice of using cmd.Dispose(); :thumbsup: All the best, Martin

Your welcome :) PS: Please don't forget to mark the post good answer :thumbsup: Harvey Saayman - South Africa Software Developer .Net, C#, SQL you.suck = (you.Occupation == jobTitles.Programmer && you.Passion != Programming) 1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111