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?

yeah that works, but I thougth would be another way to do that. Anyway thanks SQLDenis

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...

but Activate() is not a member of TextBox Class

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?

I know a way to do that, but... well check it and decide by yourself Save the excel worksheet as a MS-DOS (*.csv) comma separated document, then you have a clear way to read the data. Example if you have this Mike 12 5.45 Jean 23 6.32 when you save the file you will have this "Mike"...

I got it, by using the "guest" user. thanks anyway

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.

thanks for the tips

But how can I do that? If the Id_Prod is autoincremental I need to know which number the DB has assigned to the record and then save in the others tables with that Id_prod

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've seen this error too. I supose you are using a DBGrid to show some queries. And the error pop ups when you are editing and you change to another record. Is it correct?

AnsiString myString = "123"; int myInteger; myInteger = myString.ToInt(); or myInteger = StrToInt(myString); I suggest you use a try catch clause to prevent a failure.

Or you can create your own font, it is very simple

Or why don't you return the Identity value? if it exists, your SP worked, else it didn't

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?

Thanks SQLBill, it is working with the dollar sign, but the comma is missing. Any other suggestion?

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