Click here to Skip to main content
16,005,339 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Executing vbscript from ASP.NET page Pin
Rizwan Bashir18-Aug-05 1:35
Rizwan Bashir18-Aug-05 1:35 
GeneralRe: Executing vbscript from ASP.NET page Pin
Anonymous18-Aug-05 2:09
Anonymous18-Aug-05 2:09 
GeneralRe: Executing vbscript from ASP.NET page Pin
paulanthony18-Aug-05 3:18
paulanthony18-Aug-05 3:18 
GeneralPrevent user from pasting into combo box Pin
Mo_developer17-Aug-05 22:56
Mo_developer17-Aug-05 22:56 
GeneralRe: Prevent user from pasting into combo box Pin
18-Aug-05 1:48
suss18-Aug-05 1:48 
GeneralRe: Prevent user from pasting into combo box Pin
Thomas Stockwell19-Aug-05 8:44
professionalThomas Stockwell19-Aug-05 8:44 
GeneralVBA Excel to SQL Server Pin
paulanthony17-Aug-05 22:46
paulanthony17-Aug-05 22:46 
GeneralRe: VBA Excel to SQL Server Pin
Mandar Patankar18-Aug-05 5:56
Mandar Patankar18-Aug-05 5:56 
'you may need to add refrences for this to work look ADO library


'DataBase Connection parameters
Public stConn As String 'Connection String
Public Cnt As New ADODB.Connection 'Connection Object
public StConn as String

stConn = "Provider=sqloledb;" & _
"Data Source=ServerName;" & _
"Initial Catalog=Database;" & _
"User Id=sa;" & _
"Password=yourpassword;"

Cnt.OPEN strconn

Qry_str = "your Query Insert,Update,Delete;"

Cnt.Execute Qry_str



Mandar Patankar
Microsoft Certified professional
GeneralRe: VBA Excel to SQL Server Pin
paulanthony18-Aug-05 6:03
paulanthony18-Aug-05 6:03 
GeneralRe: VBA Excel to SQL Server Pin
ulchris18-Aug-05 10:02
ulchris18-Aug-05 10:02 
GeneralHelp with Crystal Reports, desperetaly in need of help Pin
korso_rogan17-Aug-05 22:24
korso_rogan17-Aug-05 22:24 
GeneralComboBox Bind Problem Pin
Greeky17-Aug-05 21:32
Greeky17-Aug-05 21:32 
GeneralFormatting 1 field in excelsheet Pin
ybasha17-Aug-05 19:54
ybasha17-Aug-05 19:54 
GeneralRe: Formatting 1 field in excelsheet Pin
Steve Pullan18-Aug-05 19:39
Steve Pullan18-Aug-05 19:39 
GeneralGet the binary content from a VC dll. Pin
rushing17-Aug-05 19:44
rushing17-Aug-05 19:44 
GeneralCreating an sql adapter,datatable and populating the fields of a grid Pin
mcupryk17-Aug-05 17:19
mcupryk17-Aug-05 17:19 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Christian Graus17-Aug-05 17:52
protectorChristian Graus17-Aug-05 17:52 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Anonymous17-Aug-05 19:20
Anonymous17-Aug-05 19:20 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Christian Graus18-Aug-05 14:49
protectorChristian Graus18-Aug-05 14:49 
QuestionGet list of machines in LAN? Pin
Jimmy Huynh17-Aug-05 16:46
Jimmy Huynh17-Aug-05 16:46 
AnswerRe: Get list of machines in LAN? Pin
Mohamad Al Husseiny17-Aug-05 16:50
Mohamad Al Husseiny17-Aug-05 16:50 
AnswerRe: Get list of machines in LAN? Pin
Steve Pullan17-Aug-05 17:26
Steve Pullan17-Aug-05 17:26 
AnswerRe: Get list of machines in LAN? Pin
Anonymous17-Aug-05 17:54
Anonymous17-Aug-05 17:54 
GeneralCalendar control in Access forms Pin
Anonymous17-Aug-05 12:43
Anonymous17-Aug-05 12:43 
GeneralRe: Calendar control in Access forms Pin
Anonymous17-Aug-05 12:44
Anonymous17-Aug-05 12:44 

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.