Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
aldm
Starting Member
2 Posts |
Posted - 2010-01-13 : 17:31:26
|
Hi,I'm new to ms sql. I installed ms sql 2008 express to my computer.In my start menu, there are only Import and Export data and Configuration Tools, which includes Sql Server Configuration Manager,Sql Server and Usage Reports and Sql Server Installation center. How can I find Querry Writter (to write querryes).Thanks in advance |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
aldm
Starting Member
2 Posts |
Posted - 2010-01-15 : 05:34:17
|
Thank you for help, I installed ms sql managment studio. But now, I have another problem.When I want to connect to base from Visual Studio 2008, it writes me error: "Cannot open database "Probna" requested by the login. The login failed.Login failed for user 'Ado-PC\Amer'."I have a database Probna. I tried to insert data from form with the following code:------------------------------------ string konekcijski = "server=ADO-PC\\SQLEXPRESS; database=Probna; User Instance=false; uid=; pwd=;Trusted_Connection=true"; SqlConnection konekcija = new SqlConnection(konekcijski); string komandni = "select * from Osoba"; SqlDataAdapter adapter = new SqlDataAdapter(komandni, konekcija); DataSet ds = new DataSet(); adapter.Fill(ds, "Osobe"); int id = ds.Tables["Osoba"].Rows.Count; DataRow red = ds.Tables["Osoba"].NewRow(); ds.Tables["Osoba"].Rows.Add(red); red["id"] = id.ToString(); red["jmb"] = textBox1.Text; red["ime"] = textBox2.Text; red["prezime"] = textBox3.Text; red["adresa"] = textBox4.Text; adapter.Update(ds, "Osoba"); ds.AcceptChanges();----------------------------------------Code is correct and I don't know what could be a problem... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-15 : 12:52:31
|
need to create a login and grant permissions for Ado-PC\Amer |
|
|
|
|
|