|
1. You have right that for importin OleDb namespace it should be like this Imports System.Data.OleDb
2. Delete ';' and debug your appliaction
here is correct code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
Dim strconn As String<br />
strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb"<br />
Dim dbconn As OleDbConnection = New OleDbConnection(strconn)<br />
Dim dbinsert As OleDbCommand<br />
dbconn.Open()<br />
dbinsert.Connection = dbconn<br />
dbinsert.CommandText = "INSERT INTO Kunder (Namn,Ort) VALUES ('Christian','Sweden')"<br />
dbinsert.ExecuteNonQuery()<br />
MsgBox("Weee")<br />
dbconn.Close()<br />
<br />
End Sub
|
|
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
Dim strconn As String<br />
strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb"<br />
Dim dbconn As OleDbConnection = New OleDbConnection(strconn) <br />
dbconn.Open()<br />
Dim dbinsert As OleDbCommand = New OleDbCommand("INSERT INTO Kunder (Namn,Ort) VALUES ('Christian','Sweden')", dbconn)<br />
dbinsert.ExecuteNonQuery()<br />
MsgBox("Weee")<br />
dbconn.Close()<br />
<br />
End Sub
|
|
|
|
|
>>> Code <<<<
>>> E-message <<<<
My knowledge of these problem is very finite
Im very thankful of ur help!!
|
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
<br />
Dim strconn As String ' here declare string variable for instance of OleDbConnection<br />
strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb" ' here initialize string variable by givin string of conenction<br />
Dim dbconn As OleDbConnection = New OleDbConnection(strconn) 'here initialize OleDbConnection with string variable<br />
dbconn.Open() 'Here open OleDb connection string<br />
Dim dbinsert As OleDbCommand = New OleDbCommand("INSERT INTO Kunder (Namn,Ort) VALUES ('Christian','Sweden')", dbconn) 'Here is initialize of OleDbCommand and here you get your error but if you use this code you should not get any error<br />
dbinsert.ExecuteNonQuery() 'Here executed OleDbCommand <br />
MsgBox("Weee") 'Here Display MessageBox with string Weee<br />
dbconn.Close() ' Here Closed your connection string<br />
<br />
End Sub
-- modified at 6:04 Friday 7th April, 2006
|
|
|
|
|
He isn't learning anything by copying and pasting your code.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I see he can't because i tyed to explain so so simple little insert command until i wrote him just to copy and paste.
|
|
|
|
|
I am trying to add an assembly to a SQL2005 database but am getting the following error:
Warning: The SQL Server client assembly 'microsoft.sqlserver.smo, version=9.0.242.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
The code I used was:
CREATE ASSEMBLY Smo
FROM 'C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SqlServer.Smo.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS
I have tried to set the database to be trusted (ALTER DATABASE [dB] Set TRUSTWORTHY ON) but that does not help.
My end goal is that I need to access some SMO (SQL Management Objects, replaces SQL-DMO) methods in a SqlServerProject. You first have to add the assembly to your database though before you can Add Reference in VS2005.
regards,
Paul Watson
Ireland
Feed Henry!
eh, stop bugging me about it, give it a couple of days, see what happens.
|
|
|
|
|
I need to decide between SQLite or Access Data Base, to build dynamically in a c++ project.
Can you please give me advantages and disadvantages for each one, and advice me wich one to use?
aukh
|
|
|
|
|
What i have is a sql script that builds tables and other objects and what i
need is to be able to run other filename.sql scripts in side of the first. For instance in oracle, I make an installer.sql and do this:
@createtable.sql
@altertable.sql
@select.sql
@insert.sql
@delete.sql
etc.....
from inside the install.sql so instead of having one really huge sql script i have many smaller ones that all get run from another filename.sql.
|
|
|
|
|
Okey, dokey, boys a girls, heres a fun one. I would like to make a database that i can import into my Visual Studio 2005. For this i usually require a SQL server... I open my Access 2003, and start a new project. I click make a table, and it brings it up... whenever i go to save it says: {TABLE NAME} is not a valid object name... i tried many different names to no avail. any ideas?
"Love, Life and Option Explicit"
|
|
|
|
|
Hi There,
Is it possible to create form at Runtime and when I click on a button create on the new form the data should get stored in database. Please Help.
Regards,
Amit
|
|
|
|
|
Amit R wrote: Is it possible to create form at Runtime and when I click on a button create on the new form the data should get stored in database
Yes.
Have a look at the code that visual studio hides from you - see how it works and implement a similar kind of thing dynamically as per the data you are interested in.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Here is a simple example,winform Application
//class level var
Form frm =new Form();
Button btn=new Button();
TextBox tb=new TextBox();
//button click event
private void button1_Click(object sender, System.EventArgs e)
{
btn.Text="Click me";
btn.Click+=new EventHandler(btn_Click);
tb.Top=btn.Top+50;
tb.Text="test";
frm.Controls.Add(tb);
frm.Controls.Add(btn);
frm.ShowDialog();
}
private void btn_Click(object sender, System.EventArgs e)
{
MessageBox.Show(tb.Text);
}
|
|
|
|
|
I would like to develop a database application.Its function is to monitor the database actions(etc login,insert,delete),record them and do some auditing. please give me some help.How to implement it.
Thank you very much!
|
|
|
|
|
[Sorry - I misread your question]
You could add triggers to each of the tables and from there put the information you want to audit into some other tables. Your audit application can then query those tables.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
-- modified at 3:16 Thursday 6th April, 2006
|
|
|
|
|
|
Hi,
I am trying to connect SQL Server 2000 thru coding in VB.NET. Code is :-
Public objsqlcon As New SqlConnection
Public Function OpenConnection() As Boolean
Try
If objsqlcon.State = ConnectionState.Closed Then
objsqlcon = New SqlConnection("DATA SOURCE=A;Initial Catalog=Data1;USER ID=sa;PASSWORD=password;")
objsqlcon.Open()
End If
OpenConnection = True
Catch ex As Exception
Throw ex
End Try
End Function
where A means alias of Server, data1 is databasename.
Is it the right code, if yes, its not working and what can be the problem, If no, what is the right code.
Note :- This code is working at my office and not at my home. whats the difference in this case.
Thanks. Waiting for a prompt & right reply.
-- modified at 12:14 Wednesday 5th April, 2006
|
|
|
|
|
rahsi wrote: where A means alias of Server
I assume by this you mean that in the actual environment you replace A with the name of the SQL Server instance?
rahsi wrote: This code is working at my office and not at my home. whats the difference in this case.
You are on a different network? If I connect to my office through my company's VPN I have to specify the full name of the SQL Server as servername.companyname.co.uk
rahsi wrote: USER ID=sa; PASSWORD=password
If you wrote that where I work the code would NOT pass a coding review. Connecting as sa is highly dangerous and exposes your SQL Server to unnecessary risks.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
-- modified at 13:28 Wednesday 5th April, 2006
|
|
|
|
|
Hi..Thanks Mackay...Its working now and the problem was with server name..which i got now...Its working properly.
Anyways, thanks a lot. see u soon.
Gurpreet
|
|
|
|
|
Any one have this issue?
I'm developing a data entry application in SQL Server/VB.Net 2005.
I noticed that when I load in data onto my form it takes a very long time to load, I'm only talking about 91K records.
I'm loading my data into a form, I have the required table adapter, dataset,
bindingsource and bindingnavigator.
Is this normal or is it inherit in Sql Server & or Vb.net?
I also notice that for changes to be propageted to the db, the user must move to the next record for the changes to be recognized.
Is there a way to update automatically?
Any help appreciated.
Mike
|
|
|
|
|
MikeUPMC wrote: I noticed that when I load in data onto my form it takes a very long time to load, I'm only talking about 91K records.
Don't pull 91K rows across from the database to your application. It is inefficient.
Do you desperately need all 91K rows on the client at once? Are you processing all 91K rows at the same time in your client?
MikeUPMC wrote: Is this normal or is it inherit in Sql Server & or Vb.net?
Neither. I would suggest it is the .NET Framework - DataGrids and the like really are not designed to handly 91K rows all at once. It will accept it, and your application will guzzle the memory it needs to support it, but it really is a bad idea.
When you make a request like that through the DataAdapter the call will complete only when all 91K rows have been pulled out of SQL Server, across the network (how much bandwidth is all this data taking?) and into your client application.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I need all records to load, users will be adding/deleting modifying to the table based on records already entered.
The app I'm designing is replacing one developed in Access.
In Access, the form loads quickly (only waiting for the record count).
All needed functions are within the database like search & replace on
a filtered dataset. Queries to Insert records into the table, and copy the table to another table for exporting.
I'm trying to mirror the functionality of the current system to that of Sql Server/VB.Net & I'm running into issues i.e. time, speed, search & replace function within a datagrid. This conversion might be more involved than I originally thought. I have the functions for the above insert/copy, and they complete, but updating the dataset is time consuming.
Mike
|
|
|
|
|
MikeUPMC wrote: The app I'm designing is replacing one developed in Access.
In Access, the form loads quickly (only waiting for the record count).
That is because it didn't load all the data at once. It loaded what was on screen plus some rows before and after the current position. It would then dynamically get more rows as required in such a way that the user would be unaware.
ADO.NET 2.0 does provide some asynchronous access methods so that you can access information in the background however I have not used them so I cannot tell you how effective they would be, or how much extra complexity they would add to your appliation.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
EXAMPLE
Database format
ID Value1 Value2
1 val1 x
2 val2 x
3 val3 x
.. ... ...
.. ... ...
...... Next 100 000 rows
I want to change values in field Value2 to value from field Value1 how to do this things....
When I using this code*, It's takes me more than 2 minutes... but it is too much, What if I will use database with milion rows??? Is it possible....
.NET is only problem and problem
When I used VB 6 with DAO it's takes me only 5 sec.
How to do this thing? please help
*Code is here
Dim con As New OleDb.OleDbConnection(ConnectionString)<br />
Dim cmd As New OleDb.OleDbCommand("SELECT ID FROM Main", con)<br />
<br />
con.Open()<br />
<br />
Dim reader As OleDb.OleDbDataReader = cmd.ExecuteReader()<br />
<br />
Dim U_cmd As New OleDb.OleDbCommand("", con)<br />
Dim IDNum As Integer<br />
<br />
<br />
Do While reader.Read<br />
IDNum = reader.GetInt32(0)<br />
<br />
<br />
U_cmd.CommandText = "UPDATE Main SET F3= '" & IDNum & "'WHERE ID= " & IDNum<br />
<br />
<br />
U_cmd.ExecuteNonQuery()<br />
Loop<br />
<br />
con.Close()
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
