Click here to Skip to main content
15,912,205 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Regular Expression for Range number (1,3,5-12) Pin
CWIZO27-Apr-06 7:25
CWIZO27-Apr-06 7:25 
AnswerRe: Regular Expression for Range number (1,3,5-12) Pin
Guffa27-Apr-06 7:51
Guffa27-Apr-06 7:51 
GeneralRe: Regular Expression for Range number (1,3,5-12) Pin
Phoen2527-Apr-06 8:38
Phoen2527-Apr-06 8:38 
QuestionCommented code still throwing an error!! Pin
macca2427-Apr-06 4:08
macca2427-Apr-06 4:08 
AnswerRe: Commented code still throwing an error!! Pin
darkelv27-Apr-06 5:40
darkelv27-Apr-06 5:40 
GeneralRe: Commented code still throwing an error!! Pin
macca241-May-06 22:16
macca241-May-06 22:16 
QuestionDraw a chart on a form Pin
codeadair27-Apr-06 3:38
codeadair27-Apr-06 3:38 
QuestionHow to export data in a dataset directly to SQL Server 7.0? Pin
Rashar27-Apr-06 3:23
Rashar27-Apr-06 3:23 
Hello,

I have populated my dataset SQLDataset, and would like to pass the data to a table in SQL Server 7.0. How do I accomplish this?

<br />
Private Sub cmdExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExport.Click<br />
<br />
        Dim DBConnection As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db1.mdf" & _<br />
        ";Integrated Security=True;User Instance=True")<br />
        Dim SQLDataset As New DataSet("db1") <br />
        Dim currentUser As String<br />
        Dim trimUserName As String<br />
        currentUser = My.User.Name<br />
<br />
        trimUserName = My.User.Name.ToUpper.ToString()<br />
        currentUser = trimUserName.Substring(9)<br />
<br />
        DBConnection.Open() 'open database<br />
<br />
        Dim dbAdapter As New SqlDataAdapter("SELECT * FROM tblContacts WHERE Status = 'NEW'", DBConnection)<br />
<br />
          dbAdapter.Fill(SQLDataset) <br />
<br />
        If SQLDataset.Tables("Table").Rows(0)(14).ToString = "NEW" Then<br />
              <br />
            'then send data to SQL Server 7.0<br />
            <br />
<br />
        End If<br />
<br />
        SQLDataset.WriteXml("c:\temp\" & currentUser & ".xml", XmlWriteMode.WriteSchema)<br />
        DBConnection.Close()<br />
<br />
<br />
<br />
<br />
    End Sub<br />

QuestionProject Pin
olarip27-Apr-06 2:52
olarip27-Apr-06 2:52 
AnswerRe: Project Pin
J4amieC27-Apr-06 3:08
J4amieC27-Apr-06 3:08 
AnswerRe: Project Pin
codeadair27-Apr-06 3:42
codeadair27-Apr-06 3:42 
GeneralRe: Project(Library management system) Pin
olarip27-Apr-06 20:48
olarip27-Apr-06 20:48 
Questionhow to build an already developed project to a setup project? Pin
Ron.S27-Apr-06 2:40
Ron.S27-Apr-06 2:40 
AnswerRe: how to build an already developed project to a setup project? Pin
codeadair27-Apr-06 3:51
codeadair27-Apr-06 3:51 
QuestionHow output msg from thread to label windows control ? Pin
ALQallaf27-Apr-06 2:31
ALQallaf27-Apr-06 2:31 
AnswerRe: How output msg from thread to label windows control ? Pin
J4amieC27-Apr-06 3:11
J4amieC27-Apr-06 3:11 
GeneralRe: How output msg from thread to label windows control ? Pin
ALQallaf27-Apr-06 3:45
ALQallaf27-Apr-06 3:45 
AnswerRe: How output msg from thread to label windows control ? Pin
codeadair27-Apr-06 3:59
codeadair27-Apr-06 3:59 
QuestionRe: How output msg from thread to label windows control ? Pin
ALQallaf27-Apr-06 4:18
ALQallaf27-Apr-06 4:18 
Questionhow to add the controls to the form dynamically? Pin
Ron.S27-Apr-06 2:08
Ron.S27-Apr-06 2:08 
AnswerRe: how to add the controls to the form dynamically? Pin
codeadair27-Apr-06 4:02
codeadair27-Apr-06 4:02 
AnswerRe: how to add the controls to the form dynamically? Pin
isroavi27-Apr-06 15:33
isroavi27-Apr-06 15:33 
Questionsearch case insensitive to access database Pin
klakero27-Apr-06 2:06
klakero27-Apr-06 2:06 
AnswerRe: search case insensitive to access database Pin
J4amieC27-Apr-06 2:28
J4amieC27-Apr-06 2:28 
GeneralRe: search case insensitive to access database Pin
klakero28-Apr-06 1:09
klakero28-Apr-06 1:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.