Hi,

Add another MainForm, And make it MDIForm by setting the property (ISMSI=True). Create Menus to show different forms. and In MenuClick, Show the Forms (In Modal)..

Regards
Veena

Hi,

You need to First Create a Public User, in "SQL Server Authentication Mode" .
and give permission to the database.
Also Select Default Database for this User.
And You need to login thru...

Hi,

Check the MSDN Help:

For each property, you can specify an integer between -32768 and 32767
inclusive.


Regards
Veena

Hi,

Sorry..
Check this link:

http://www.gamerzplanet.net/forums/visual-basic/247884-settings-file-reader-writer-vb2008.html

REgards
Veena

Hi,

Check this link:
"http://www.gamerzplanet.net/forums/visual-basic/247884-settings-file-reader-writer-vb2008.html"

Regards
Veena

Hi,

Try this condition :


If Combo1.SelectedIndex = 0 Then
' Code to disable
Else
' Code to Enable
End If

Hi,

I guess, you can use this :


MsgBox("Selected Rows : " & DataGridView1.SelectedRows.Count.ToString())


Regards
Veena

Hi,

Try This :


Private Sub Text1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Text1.KeyPress
If e.KeyChar <> ChrW(Keys.Back) Then
...

Hi,

Check this link:

http://www.a1vbcode.com/app-3859.asp

REgards
Veena

Hi,

I dint get u, U already r appending outside the loop, what u want to do here..?

REgards
Veena

Hi,

.net dosent have a special Script Control. so u need to use COM script. Check this (http://searchvb.techtarget.com/tip/0,289483,sid8_gci1045916,00.html)

Regards
Veena

Hi,

then mark the thread as Solved....
Since it was not marked, i thought , ur problem is still hanging..

Regards
Vee

Hi,

ur SQL Statemnt should contain all the 3 tables names:


sql = "SELECT ThresoldTable.* FROM thresholdTable,Configuration,Consistency Where Configuration.Configuration =...

Hello,

u cant give the thresholdTable name in Dataset like that...

Proper Syntax is:

Dim da As OleDbDataAdapter = New OleDbDataAdapter(sql, conn)
da.Fill (MydataSet,"ThrTable")

Hi,

Post the whole SQL Statement here. Such error occur when u have Mis-Spelled the Column Or Table Name.
I noticed it now Remove the Comma in the Relationship and give AND there. Check This:
...

Hi,

Start with Access (mdb) file.
Collect all the necessary info u need to store in db. then u can start designing the database. If this is ok, and if ur DB is huge, u can shift to SQL Server.
...

Hi,

In case u have one more table, include that also in SQL Statement and give appropriate links..

Regards
Veena

Hi,

Then give one more condition in where:


sql = "SELECT T.* FROM thresholdTable T, Configuration C Where C.Configuration = T.Config And C.Consistency = T.Consistency"


u can give any...

Hi,

check this:


sql = "SELECT T.* FROM thresholdTable T, Configuration C Where C.Configuration = T.Config"



Regards

Hi,

I just didnt realise that.. Yes u will have to use StreamWriter, to write the file..

Any way, good, ur problem is solved..

Regards
Veena

Hi,

Check This (http://www.activexperts.com/activsms/howto/gsm/vbnet/) and also Download examples from the same site...

REgards
Veena

Hi,

I'am not clear what u r asking for..?
Did u mean to use "CStr()" Function..?

Regards
Veena

Hi.

Check This (http://vb-helper.com/howto_net_use_vsa.html)

Regards
Veena

Hi,

Have u tried my code..?

Regards
Veena

Hi,

if u r talking abt Serial Port then check this (http://www.codeworks.it/net/VBNetRs232.htm)

Regards
Veena

Hi,

Read This Step By Step (http://www.oracle.com/technology/pub/articles/cook_dotnet.html) Intsructions

Regards
Veena

Hi,

use Val() function check this :


num1 =Val(InputBox("Please enter a number"))


Even if user enters some Text chars, u get its value as zero..
May be u can write check after that to...

Hi,

Just Get the Stored procedure to output these parameters, If the Search is Matched..:

TableName, FieldName, FieldValue, ID of the Matched record.

If user selects some thing from the...

Hi,

Download the Source/Demo file of DataBound ListView Control HERE (http://www.codeproject.com/useritems/DBListViewForV2.asp).


It is for ASP.net, easily, u can convert it to ur VB.net...

Hi Kshiteesh,

few points what i have noted here...:

1. Before Creating the DataAdapter, u are not checking if "S" is blank or not.. the error which u have may be the same..
or else in ur...

Hi,

OK, then u need to parse the whole text file..

Open the TextFile, read the Contents, and check if the Hotsname is already present... else add..
check this code:


Dim sw As...

Hi,

Use DataReader which is very fast. Check This Code:


Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
cn = New...

Hi,

u can also check this (http://aspalliance.com/articleViewer.aspx?aId=138)

Regards
Veena

Hi,

u can check the Storedprocedure here (http://vyaskn.tripod.com/sql_server_search_and_replace.htm)
It Checks and Replaces, u can modify it to Check and Return back...

Regards
Veena

hi,

In Total how many tables do u need to do search operation..?
If Many Tables, and many recs in each table, then this will be a huge Overhead on the database.
But if u need to do it...

Hi,

Keep a Public Project Level Variable To Populate Building Selected in first Form. And While Loading Second Form Filter Records for only the Selected Parameter using "Where" Condition in the...

Hi,

What is the Database u r using..? Access..?

-Vee

Hi,

what u actually want..? Search all the fields of all the tables for any one Specific condition...?

-Vee

Hi,

Sorry that was C code not vb
And Recordset Object does exist in VB.net..

check this :

Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=K:\Database\db1.mdb"
Dim...

Hi,

Check this Code:
Add a Datgrid to ur Form.


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim sSQL As String
Dim DA As...