pervii ras rabotay s ado.net — ne polychaetsa dobavlat dannie.. nikak ne poimy v chem problema, nikogda takogo ne bilo, delal tog samoe s ado:

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=lynx;database=ishop;uid=is_auto;pwd=is_auto";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into is_users (login) values ('login')";
//cmd.CommandText = "create table is_users (id_usr int identity, login varchar(10), passw varchar(10), lname varchar(20), fname varchar(20), sname varchar(20), address varchar(50), email varchar(20), phone varchar(13) )";
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
Literal2.Text = ex.Message;
Literal2.Text += conn.ConnectionString;
}
finally{
conn.Close();
}
//////////
exception log:
INSERT permission denied on object 'is_users', database 'ishop', owner 'is_auto'.
server=lynx;database=ishop;uid=is_auto;