The responses you have assume that the databases are on the same server, in which case database.owner.tablename will work. If they are on different servers you have a problem, you need to set up linked servers, something I hate doing as the server is then hard coded into the query. Never underestimate the power of human stupidity RAH

abglorie wrote: Please give me actual query No, we are not here to do your work. I know the language. I've read a book. - _Madmatt

http://tinyurl.com/mehqwx[^]

Now typing in msword document using equation editor and type matrix (i.e. 3 row 4 columns). 1 0 1 1 1 1 0 1 0 1 1 0

The only way to store two pieces of data in one field, is to combine them, for example, in a zip. If you were to store them in two fields, then it would be a lot easier. How do you do it ? With SQL, it's got to be one of the most answered questions on the web, and if you bothered to google it, you'd get far more in depth examples and answers than you'll ever get in a forum reply Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

i have a code in C# for access database make an upload folder in your project file Label1.Text = Server.MapPath(@"~/Upload/" + FileUpload1.FileName.ToString()); FileUpload1.SaveAs(lbl_path.Text); Image1.ImageUrl = "~/Upload/" + FileUpload1.FileName; Label1.Text = FileUpload1.FileName; and now through insert command save Label1.Text into your database and for retrieving the picture and for retrieving the picture use select command give id of that row in some textbox cmd=new oledbcommand("Select Image from Images where ID='"+textbox1.text+"'",con); rd=cmd.executereader(); if(rd.read()) { textbox2.text=rd["Image"].tostring(); Image1.ImageUrl=@"~\upload\"+textbox2.text; } hope it works

I am agree what sashidhar suggested, You can do one more thing, rather than sotring image in DB in byte format, store image in your hard drive and store the path in Database. Retreive the path from database, and display the image from your hard drive. This will make your task simple. Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

already enabled anonymous access checkbox my website description is XYZ IP address is (all unassigned) TCP port is 150

Re: Please Dont Cross Post:mad:

write like this Select * from FILE1 where Cast(substring(mycode,3,2) as int)=10 Abhishek Sur

If you read all my responses, you'll see there are Indian developers I have nothing but respect for. Then there's this guy.... Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

if you use parameterised queries it solves both a) The apostrophe problem and b) the sql injection vulnerability problem.

abglorie wrote: I type name then press enter key. The cursor go to next textbox2. How to made it in this action? hi abglorie, If you are doing asp.net that means by pressing Enter you call round trip OR make page to visit server. So either you use TabIndex property of textbox or call javascript function on keypress event which changes focus of textboxes. But according to me it's better to use TabIndex property becuase Enter button is important for sever side execution also no need to call javascript function each time after pressing Enter. Hope you will choose best solution. Dilip Kumar Vishwakarma Programmer .Net Consulting

abglorie wrote: MySql = "UPDATE MyTable SET Title='" & MyText & "' Where Title='Womens Studies'" Use parameterized query. Read about SQL injection attacks. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Please read the forum guidelines. You have started several threads in which the message title has absolutely no meaning. Also, asking for the code is considered rude. You are expected to at least try programming and if you get stuck we will help. http://craptasticnation.blogspot.com/[^]

hello abglorie, in the database change the datatype of the datefieldname as varchar(50) u will get or in the query write it as select convert(varchar(10),getdate(),101) or 103 ok byee murali

abglorie wrote: I try the session state but not working. I doubt that. Looks like you're storing the dataset in the session, that will work just fine. It obviously won't display anything, and is a waste of time if you don't need this data on another page. ds.Tables(0).Rows(0)("id") should work, assuming hte column name is id. I recommend reading a book on ADO.NET so you can do this without just stabbing blindly at it. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

A few points. 1. Just because it's very urgent for you doesn't mean that it even makes the top 10,000 urgent items I have on my plate right now. So don't bother marking it as urgent. Is it any more urgent than the issues that the other posters have? 2. We don't do homework for you. 3. If you want the code, I would suggest that you go to rentacoder. 4. You'll get decent responses if you try this task yourself, and then ask for help on individual areas that have got you stuck. Deja View - the feeling that you've seen this post before.