473,321 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

SQL query

Is there a command to do a query for an SQL database?
I managed to make a sql connection variable, and to take info from it
by making a SqlDataAdapter with select query in it, and filling the
dataset with it.
If I want to do an insert query, I can't, because it is not saved in
the DB, and when I close the application I can't access it any more.
This is what I did:

SqlConnection cn = new SqlConnection();
SqlDataAdapter da;

cn = table1TableAdapter.Connection;
cn.Open();
da = new SqlDataAdapter("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
da.InsertCommand = da.SelectCommand;
da.Fill(myDBds, "Items");
cn.Close();
How do I query?
Please help,
Ofir.

Jun 1 '07 #1
13 2615
On Jun 1, 8:14 am, ofiras <ofi...@gmail.comwrote:
Is there a command to do a query for an SQL database?
I managed to make a sql connection variable, and to take info from it
by making a SqlDataAdapter with select query in it, and filling the
dataset with it.
If I want to do an insert query, I can't, because it is not saved in
the DB, and when I close the application I can't access it any more.
This is what I did:

SqlConnection cn = new SqlConnection();
SqlDataAdapter da;

cn = table1TableAdapter.Connection;
cn.Open();
da = new SqlDataAdapter("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
da.InsertCommand = da.SelectCommand;
da.Fill(myDBds, "Items");
cn.Close();

How do I query?
Please help,
Ofir.
SqlConnection cn = new SqlConnection();
SqlCommand cmd;

cn = table1TableAdapter.Connection;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();

Jun 1 '07 #2
On Jun 1, 1:14 pm, ofiras <ofi...@gmail.comwrote:
Is there a command to do a query for an SQL database?
I managed to make a sql connection variable, and to take info from it
by making a SqlDataAdapter with select query in it, and filling the
dataset with it.
If I want to do an insert query, I can't, because it is not saved in
the DB, and when I close the application I can't access it any more.
The other reply explained how to do it, but the important thing to
note is that an insertion *isn't* a query - it's adding data, not
reading it.

Jon

Jun 1 '07 #3
On Jun 1, 2:29 pm, z...@construction-imaging.com wrote:
On Jun 1, 8:14 am, ofiras <ofi...@gmail.comwrote:
Is there a command to do a query for an SQL database?
I managed to make a sql connection variable, and to take info from it
by making a SqlDataAdapter with select query in it, and filling the
dataset with it.
If I want to do an insert query, I can't, because it is not saved in
the DB, and when I close the application I can't access it any more.
This is what I did:
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
cn = table1TableAdapter.Connection;
cn.Open();
da = new SqlDataAdapter("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
da.InsertCommand = da.SelectCommand;
da.Fill(myDBds, "Items");
cn.Close();
How do I query?
Please help,
Ofir.

SqlConnection cn = new SqlConnection();
SqlCommand cmd;

cn = table1TableAdapter.Connection;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thenks, but still if I close the aplication, There is no "milk" item
any more.
Why the DB is not changed?
Please help,
Ofir.

Jun 1 '07 #4
On Jun 1, 1:35 pm, ofiras <ofi...@gmail.comwrote:
Thenks, but still if I close the aplication, There is no "milk" item
any more.
Why the DB is not changed?
Do you have something else setting up a transaction? If so, you'll
need to commit the transaction.

Jon

Jun 1 '07 #5
On Jun 1, 8:35 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 2:29 pm, z...@construction-imaging.com wrote:


On Jun 1, 8:14 am, ofiras <ofi...@gmail.comwrote:
Is there a command to do a query for an SQL database?
I managed to make a sql connection variable, and to take info from it
by making a SqlDataAdapter with select query in it, and filling the
dataset with it.
If I want to do an insert query, I can't, because it is not saved in
the DB, and when I close the application I can't access it any more.
This is what I did:
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
cn = table1TableAdapter.Connection;
cn.Open();
da = new SqlDataAdapter("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
da.InsertCommand = da.SelectCommand;
da.Fill(myDBds, "Items");
cn.Close();
How do I query?
Please help,
Ofir.
SqlConnection cn = new SqlConnection();
SqlCommand cmd;
cn = table1TableAdapter.Connection;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();

Thenks, but still if I close the aplication, There is no "milk" item
any more.
Why the DB is not changed?
Please help,
Ofir
As another responder indicated, if the above code doesn't work, then
you aren't showing us the entire problem. I have done this same type
of code hundreds of time, shit thousands, and it works just fine.

Are you sure your code isn't throwing some exception you are telling
us about?

Jun 1 '07 #6
Hi,
You do not need a dataadapter in this case, this code will work

SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;

cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Jun 1 '07 #7
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.comwrote:
Hi,

You do not need a dataadapter in this case, this code will work

SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;

cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:

Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;

public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}

private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}

private void Form1_Load(object sender, EventArgs e)
{
}

private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}
}

The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).

Jun 1 '07 #8
On Jun 1, 10:57 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA

laceupsolutions.comwrote:
Hi,
You do not need a dataadapter in this case, this code will work
SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();

Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:

Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;

public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}

private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}

}

The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).
The only thing that doesn't look right is the insert statement implies
that the cost column is a varchar field (value wrapped with singe
quotes). But the Where clause on the select statement implies that it
is a numeric field (no single quotes).

Have you verified the actions with the backend? IE, Enterprise Manager
open table function or Query Analyzer?

Jun 1 '07 #9
On Jun 1, 5:10 pm, z...@construction-imaging.com wrote:
On Jun 1, 10:57 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.comwrote:
Hi,
You do not need a dataadapter in this case, this code will work
SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:
Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;
public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}
}
The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).

The only thing that doesn't look right is the insert statement implies
that the cost column is a varchar field (value wrapped with singe
quotes). But the Where clause on the select statement implies that it
is a numeric field (no single quotes).

Have you verified the actions with the backend? IE, Enterprise Manager
open table function or Query Analyzer?
Everything works, it's just that it doesn't insert what I wanted to
the DB.
I tested it, and it seems like he doesn't save it on the data source,
nor on the connection, nor on the data adaptor.
It seems like he writes it to a temporary DB, and when I close the DB
it is gone, or it might be that he writes it to the db, and erase when
I close the application.
Can you please try it on your computer and tell me why is it
happening?
You can download it from http://www.mediafire.com/?bbe0yty4mzs
To try it I press on the first button (the one that says "Press!!!")
and then on the second one. That should show you a message that says
"milk", but if you the application, open it again, and press on the
second button without pressing the first, it shows an exception while
it shouldn't.

Thank you all so much,
Ofir.
Jun 1 '07 #10
On Jun 1, 5:10 pm, z...@construction-imaging.com wrote:
On Jun 1, 10:57 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.comwrote:
Hi,
You do not need a dataadapter in this case, this code will work
SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:
Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;
public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}
}
The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).

The only thing that doesn't look right is the insert statement implies
that the cost column is a varchar field (value wrapped with singe
quotes). But the Where clause on the select statement implies that it
is a numeric field (no single quotes).

Have you verified the actions with the backend? IE, Enterprise Manager
open table function or Query Analyzer?
Everything works; it's just that it doesn't insert what I wanted to
the DB.
I tested it, and it seems like he doesn't save it on the data source,
nor on the connection, nor on the data adaptor.
It seems like he writes it to a temporary DB, and when I close the DB
it is gone, or it might be that he writes it to the db, and erase when
I close the application.
Can you please try it on your computer and tell me why is it
happening?
You can download it from http://www.mediafire.com/?bbe0yty4mzs
To try it I press on the first button (the one that says "Press!!!")
and then on the second one. That should show you a message that says
"milk", but if you the application, open it again, and press on the
second button without pressing the first, it shows an exception while
it shouldn't.

Thank you all so much,
Ofir.
Jun 1 '07 #11

"but if you the application" = but if you close the application...

Jun 1 '07 #12
On Jun 1, 11:51 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 5:10 pm, z...@construction-imaging.com wrote:


On Jun 1, 10:57 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.comwrote:
Hi,
You do not need a dataadapter in this case, this code will work
SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:
Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;
public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}
}
The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).
The only thing that doesn't look right is the insert statement implies
that the cost column is a varchar field (value wrapped with singe
quotes). But the Where clause on the select statement implies that it
is a numeric field (no single quotes).
Have you verified the actions with the backend? IE, Enterprise Manager
open table function or Query Analyzer?

Everything works, it's just that it doesn't insert what I wanted to
the DB.
I tested it, and it seems like he doesn't save it on the data source,
nor on the connection, nor on the data adaptor.
It seems like he writes it to a temporary DB, and when I close the DB
it is gone, or it might be that he writes it to the db, and erase when
I close the application.
Can you please try it on your computer and tell me why is it
happening?
You can download it fromhttp://www.mediafire.com/?bbe0yty4mzs
To try it I press on the first button (the one that says "Press!!!")
and then on the second one. That should show you a message that says
"milk", but if you the application, open it again, and press on the
second button without pressing the first, it shows an exception while
it shouldn't.
It is starting to sound like a connection issue. I do not have or have
ever used SQLExpress, so sorry, I cannot test your code.

Jun 1 '07 #13
On Jun 1, 9:12 pm, z...@construction-imaging.com wrote:
On Jun 1, 11:51 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 5:10 pm, z...@construction-imaging.com wrote:
On Jun 1, 10:57 am, ofiras <ofi...@gmail.comwrote:
On Jun 1, 3:55 pm, "Ignacio Machin \( .NET/ C# MVP \)" <machin TA
laceupsolutions.comwrote:
Hi,
You do not need a dataadapter in this case, this code will work
SqlConnection cn = new SqlConnection();
cn.ConnectionStirng = "YOUR CONNECTION STRING";
SqlCommand cmd;
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')",cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Thank you all so much for trying to help me! I was trying to do this a
lot of time...
Actually, it's a windows application.
The full code of it is:
Using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Store
{
public partial class Form1 : Form
{
SqlConnection cn = new SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;
public Form1()
{
InitializeComponent();
cn.ConnectionString = "Data Source=.\
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Data base1.mdf;Integrated
Security=true;User Instance=True";
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new SqlCommand("INSERT INTO Table1(item,title,cost)
VALUES('milk','low fat','100')", cn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
cn.Open();
da = new SqlDataAdapter("SELECT * FROM Table1 WHERE
cost=100", cn);
da.Fill(myDBds, "Items");
MessageBox.Show(myDBds.Tables["Items"].Rows[0]
["item"].ToString());
cn.Close();
}
}
}
The first button adds the "milk" item, and the second shows the item
so I can check if it exists.
If I press on the first one, and then the sound it's all ok, but if I
close the program, open it again and press the sound button there is
an exception that there is nothing with cost 100 - it wasn't saved in
the db itself, and I don't know where it was. I believe that in the
myDBds (the detasource).
The only thing that doesn't look right is the insert statement implies
that the cost column is a varchar field (value wrapped with singe
quotes). But the Where clause on the select statement implies that it
is a numeric field (no single quotes).
Have you verified the actions with the backend? IE, Enterprise Manager
open table function or Query Analyzer?
Everything works, it's just that it doesn't insert what I wanted to
the DB.
I tested it, and it seems like he doesn't save it on the data source,
nor on the connection, nor on the data adaptor.
It seems like he writes it to a temporary DB, and when I close the DB
it is gone, or it might be that he writes it to the db, and erase when
I close the application.
Can you please try it on your computer and tell me why is it
happening?
You can download it fromhttp://www.mediafire.com/?bbe0yty4mzs
To try it I press on the first button (the one that says "Press!!!")
and then on the second one. That should show you a message that says
"milk", but if you the application, open it again, and press on the
second button without pressing the first, it shows an exception while
it shouldn't.

It is starting to sound like a connection issue. I do not have or have
ever used SQLExpress, so sorry, I cannot test your code.
Ok, thanks.
Dose someone have an example for SQL insert, select or things like
that?
Everything will work, but SQLExpress will be better.
If you have, please send it to me, or upload it and write the link
here.
Thanks a lot,
Ofir.

Jun 2 '07 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: jaysonsch | last post by:
Hello! I am having some problems with a database query that I am trying to do. I am trying to develop a way to search a database for an entry and then edit the existing values. Upon submit, the...
29
by: shank | last post by:
1) I'm getting this error: Syntax error (missing operator) in query expression on the below statement. Can I get some advice. 2) I searched ASPFAQ and came up blank. Where can find the "rules"...
9
by: netpurpose | last post by:
I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use...
3
by: Harvey | last post by:
Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says...
4
by: Diamondback | last post by:
I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets...
14
by: Dave Thomas | last post by:
If I have a table set up like this: Name | VARCHAR Email | VARCHAR Age | TINYINT | NULL (Default: NULL) And I want the user to enter his or her name, email, and age - but AGE is optional. ...
0
by: starace | last post by:
I have designed a form that has 5 different list boxes where the selections within each are used as criteria in building a dynamic query. Some boxes are set for multiple selections but these list...
6
by: jjturon | last post by:
Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID ...
4
by: Stan | last post by:
I am using MS Office Access 2003 (11.5614). My basic question is can I run a query of a query datasheet. I want to use more that one criteria and can not get that query to work. I thought I...
6
by: jsacrey | last post by:
Hey everybody, got a secnario for ya that I need a bit of help with. Access 97 using linked tables from an SQL Server 2000 machine. I've created a simple query using two tables joined by one...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.