Search results for query: *

I'm using VS 2005 and I have finished the app, this app uses an external dll but I need this dll to be placed in the same directory that my app. So the questions is when I'm publishing the app, how can I add files to the installation project?

I'm comparing dates, but the values stored in the DB contains the time part too. I just need for example if I use the following code SELECT GETDATE() I get 2006-04-19 12:51:01.827 I just need the date Is there any function o way to get just the date??? Deeply I need to do something like...

I don't know if I'm doing something wrong I'm binding others controls and it is very easy, but the pictureBox doesn't work I mean textBoxAny.DataBindings.Add("Text",dataSet.Tables["MyTable"],"MyTextField");//OK...

I want to select all the text when the control gets the focus. I mean this private void textBoxDesc_Enter(object sender, EventArgs e) { textBoxDesc.SelectAll(); } But the text doesn't get selected, why?

How can I get a connection to Sql Server without being connected to the server? I mean, if I want to run my app, first I need to be logged in to the server by using the my network places, then I put my user name and password, this is exactly what I want to ommit. I just wanna run my app.

How can I insert in 2 or more tables using a single query? I wanna do this: Table_1: Id_Prod Name Table_2: Id_Prod Any_Other_Data So if I need to fill it it should be like this Table_1 Id_Prod = 1 Name = 'Something'; Table_2 Id_Prod = 1 Any_Other_Data = 'Any In Record # 1' Id_Prod = 1...

I want to make a VPN, but first I want to know what do I need? Like what kind a IP address, software, hardware etc? Or please tell me where can I find some tutorials.

I have set the configuration in Access Restrictions, I checke the "Deny Internet access during selected days and hours" I put the range of IP's but it doesn't work. What else should I do?

I have in a stored procedure a query that returns a number, but I need it formatted like if it where money. How can I do that? something like this: SELECT MyField FROM AnyTable MyField is the result of some real and integer calculations and I want it like this $1,256.23

what is better or what is the best option? What is the advantage of using them (stored procedures?

I have a DB in MS Access, I have set a password to avoid being open by the end user. Access asked me to create a .MDE File, I did it. But when I'm trying to test the connection it says something like if I missnig something in the connection string. Could anybody tell me how a connection...

I have never used a DLL, but I want to use it the next way, please tell me if I'm wrong. I want to isolate the visual code(what the user can see) and the modules that make the real job to do the program. Bt that modules I want it in a DLL, that way, if I have to modify the program I just have...

How can I extract the value of a BLOB type to an Image component without using a DBImage? Like this: Image.Picture.Bitmap = ImageField.Value; I tried using this: Image.Picture.Bitmap = ImageField.AsBCD; I guess I need to cast but how?

Is there a table that contains all the tables names?? And what about the temporal tables?

I want to save in a field the current date, it could be done in the program just assignint the hostdate, but it can be changed by the user. So is there a way or a table that contains the current date in the server?

How can I save an Image in a Database without using the DBImage Component?? I mean this: MyTable_ImageField = Image->Picture... etc. MyTable->Post(); ImageField is a BLOB type field

I'm trying to practice making some back ups and restoring data. But I have some doubts. What is the difference between *.mdf and *.ldf files?? When Im' goin to make a back up it ask me for a name, so which extension should I use?

How can I make a back up of my db?, and if I need to use the back up, how can I restore it to the db?

SQL Server Documentations says: char = Fixed-length non-Unicode character data with a maximum lebgth of 8000 characters. varchar = Variable-length non-Unicode data with a maximum length of 8000 characters. if I want fields Name & LastName which should I use and why? so what's the difference...

Query->Close(); Query->SQL->Clear(); Query->SQL->Add("SELECT *"); Query->SQL->Add("INTO MyTable"); Query->SQL->Add("FROM OriginalTable"); Query->ExecSQL(); It doesn't work!! Also I put the SQL code into a ADOCommand if I double click the command in design time it works (put the query into...