Search results for query: *

regular expressions ???

Why do you want to enter the date in string format? It's not necessary. Instead you could do something like - try to cast the string date input "dDate" to a date type. If successful, then execute the query otherwise don't. The "dDate" parameter is best used in the SQL query as a date type...

You'd probably want to re-write the SQL statement as: "SELECT Folder.FolderID, Folder.FirstName, Folder.LastName, Address.Address1, Address.City, Address.State, Address.Zip, Address.PrimaryPhone, Folder.DeathDate, Folder.BirthDate FROM Folder INNER JOIN Address ON Folder.FolderID =...

I also had the same problem with MS Access and .NET DateTime, but then I used OleDbParameters instead of passing variables in the SQL string. Works fine.

Have you tried re-configuring the table adapters?

textbox1.Text = My.Settings.AccessCON

hi, You could use a sql query to count the number of records with the matching username and password. If the count = 0 then not validated else validated. The sql query could be like this: SELECT COUNT(*) FROM USERINFO WHERE (USERNAME = ? AND PASSWORD = ?)

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click, _ Button3.Click, Button4.Click, Button5.Click, Button6.Click, Button7.Click, Button8.Click, Button9.Click, Button10.Click, _ Button11.Click, Button12.Click...

ControlToValidate="UserName"

You have to put the name of your textbox in place of "TextBox1"

You could use the regular expression validator control to validate the textbox. Here is the sample HTML code.. <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1"...

You can try the following steps: 1. Create a dataadapter and a dataset. 2. Use the dataadapter to fill the dataset with the contents of the table from SQL Server. 3. Use either the WriteXML(...) or WriteXMLSchema(...) method of the dataset to write a XML file. Hope this helps.

by short file names do you mean the 8.3 format ?

.net2003???? i think you probably mean .net1.1 but your primary platform is listed as .net2.0

wouldn't it be easier just to use command.executeNonQuery() rather than using a dataadapter, as I do not see any datasets there... cheers Ashish.

I think you have got the order a bit mixed-up. 1. declare a tablestyle. 2.declare columnstyles. 3. size column styles. 4. add columns to tablestyle. 5. add tablestyle to datagrid.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'load data into the dataset Me.DataSet11.Employees.Clear() Me.OleDbDataAdapter1.Fill(Me.DataSet11.Employees) 'create the column of the listview at runtime...

Code snippet for sending a Crystal Reports via e-mail in excel format.

Its a pleasure.. But it would really be nice to know of a way to databind to the datatablecollection collection.

For Each table As DataTable In Me.DataSet1.Tables Me.ListBox1.Items.Add(table.TableName) Next