Got the answer create table #countlists (ICount int) exec ('insert into #countlists(ICount) select COUNT(['+@v_COLUMN_NAME+']) from '+@DataTable+' where '+@v_COLUMN_NAME+' is not null') set @vCount=(select ICount from #countlists) drop table #countlists

Hi, HI, SELECT @vCount=('select COUNT(['+@v_COLUMN_NAME+']) from '+@DataTable) print @vCount This is my stored procedure part to find the count of a column specified.But here i m getting a conversion error vCount is declared as int seeism

HI, SELECT @vCount=('select COUNT(['+@v_COLUMN_NAME+']) from '+@DataTable) print @vCount This is my stored procedure part to find the count of a column specified.But here i m getting a conversion error vCount is declared as int

Hi, I have a function which can add custom column types to my table.In that there is a provision to delete the columns also.So when deleting my column i need to check whether this column contains any data or not.How to do this> Seeism

Thanks a lot.I didnt copy the code for showDialog.I was using some stream and all and it wasnt worked.I changed the code now using File.copy and it is working fine.thanks a lot

Hi, I got the file in binary format from db.Now i want to save this file in some location given by the user by a file save as dialog option without opening it. String new_FileName = Path.ChangeExtension(Path.GetTempFileName(), filetype); File.WriteAllBytes(new_FileName, result); FileDialog fldlg = new SaveFileDialog(); fldlg.InitialDirectory = "c:\\";// @":D\"; fldlg.Filter = "*.jpg|*.gif|*.txt|*.doc|*.pdf|*.htm"; fldlg.FileName = filename; This is my code.I did like this But file is not saving

Hi, Instead of opening the binary data from db in a file is it possible to store this in a file in some locations given by the user. Like if my binary file is a doc file i should store that file in some location say c:\file.doc. seeism

Hey , i found the solution.My data type that i put is binary so there is a limitation to the size.You have to put the type as image then size wont be a probs.So fix the solution.thanks for al the help; seeism

I use coloumn name also .But same happening.

if (dt.Rows.Count > 0) { result = (byte[])dt.Rows[0].ItemArray[0]; filetype = (String)dt.Rows[0].ItemArray[1]; } String new_FileName = Path.ChangeExtension(Path.GetTempFileName(),filetype); File.WriteAllBytes(new_FileName, result); System.Diagnostics.Process.Start(new_FileName); THis is my code i will get bytes in result array and filetype also.SO depending on that I am opening the file to display the data

Hi, I am downloading a binary document from sql server and depending upon my file extn it should either open doc txt or image.For txt it is working fine while for word it is saying"Word experience an error in opening the file".While for jpg image viewer is opening but no image is there What could be the reason I am using windows application in C#

Hey my probs was solved.oops that was a mistake in the stored proc where i didn mentioned the size of binary data.SO only one data was storing:) thanks a lot for ur help.

I am not much familiar with sql server.How to view the binary data in sql server. ??

Soory i pasted the code for txt here.I put it as doc while opening the doc file.For doc file it is coming junk data.For txt first char is printing SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable()); dt.Load(dr); result = (Byte[])dt.Rows[0]["File_Doc"]; when i check this result array it is contiaing the first byte value and all others r zero Why so

Hi, I am able to read only the first char of bytes from db.What could be the reason.Now in txt file ,it is opening and prints the first char but for doc,it is coming junk data seeism

Hi, I am not getting any error.I just want to open a file in the same application and now my problem is solved using this String new_FileName = Path.ChangeExtension(Path.GetTempFileName(), "txt"); File.WriteAllBytes(new_FileName, result); System.Diagnostics.Process.Start(new_FileName); But now i getting junk values for doc data.:(

hey thanks for that this is what i actually want.Now i able to open a word document if my file that stored was doc but it is coming as junk value.What could be the reason ??? seeism

Hello, I am using C# desktop applications.Here I am saving some files into the database and i wanted to read those files back and depending upon my extension it should open in corresponding files.For eg,.doc file in msword,pdf in adobe like that. I am facing a problem in opening the file .I have binary data in a byte array.How will i do it.Please help seeism