Search results for query: *

Here's the INSERT command of the dataset: (The type is ansistring. provider type is varchar - like I setup in SQL command). <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [tbl_clients] ([client_cell_num]...

Ok. Is this what you asked for? <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT client_id, client_cell_num, client_company_name, client_email, client_first_name, client_last_name, client_work_num, client_zehut_num FROM tbl_clients</CommandText>...

I don't use a query for getting the data from the database. The dataset in VB gets it with a table adopter and the combo box is bound to the dataset.

I posted it: Me.VINEWOODSTUDIOS_DataSet.tbl_clients.Columns.Add("FullName", GetType(String), "client_id +' ' + client_first_name + client_last_name")

UPDATE: I've managed to get the text aligned by using a fixed font (eg: courier) but now I still have the trailing spaces in the combo although the SQL is using VARCHAR which is supposed to hide the trailing spaces. In the FORM_LOAD I tried without trim, which gives me the following result...

The fields of first and last name are set to varchar(15) to eliminate the empty spaces but when running, the names in the combobox have a weird spacing issue. What's wrong? I'm using VS 2015, VBnet windows form.

yes... that's what I did. relevant dll's and switch connection strings. Well, I never accessed the database directly through code, so I never needed to know what kind of database it was. I only hosted a Forum on the database, which was a free php coded form that self intstalled itself (phpBB).

Fixed I just switched the code to MySql instead of Sql. All works. :-) My server was using MySql.

scenario: 1. I have a windows application (VB.NET) that will be used by workers who are all on a network. Each user of course, has his own username and password that he uses to log into windows on the network. 2. I have a MySql database Online that has a users table and a data table. The...

Connection String not Connecting... I'm trying to connect to my Online server via a webservice. This is my code: Dim sqlConn As New SqlConnection( "Server=sql2a.adcd.co.il; Database=****; UId=******; Pwd=*****;") sqlConn.Open() ...... (more code) ********************* (Of course the...

Resolved! This is what I found, did, and it works! *************** (http://pluralsight.com/blogs/keith/archive/2005/06/01/9698.aspx) Thanx i've been trying to sort this for an age. Something so simple is always the answer. Don't make the app_code or bin the subdir of the directory that...

How to publish my Web Service? ok, I made a simple Web Service just to try out my skills. All it does is adds two integers: <WebMethod()> _ PublicFunction add(ByVal x AsInteger, ByVal y AsInteger) AsString Return x + y EndFunction When I add this web service to a Windows application, it...

be carefull... Be carefull what you wish for.... :-)))) I will be working and researching on this webservice for the next 2 days! I will have questions.... but feel free to tell me ENOUGH! :-)) Thanks for the help!!

You are correct yes, I totaly agree with you. With my program though, it's so simple that I think it will be ok. 1. The only data is time and time calculations. No real data proccessing. 2. The only time the user would need to query the data is if he does a query on how much time he spent on...

re: yes, I will go with a webservice. But I didn't understand the last line you wrote... "As for caching data locally when offline that is another can of worms " Are you reffering to the fact that my program will be saving data with variables before transfering the data to the webservice (and...

I have a question. I have an SQL database residing on a web server: Server: sql2a.somesite.co.il database: DBname, I have an offline VB.NET program, residing on my computer, getting data from users and saving them in variables (no database), on computers with internet connection...