Search DaniWeb - sqlconnection

How to Reduce Qty from Stock Table when Sales qty using vb.net and sql 6 Years Ago by Maheshwaran sqlconnection = new SqlCeConnection(ConnectionString); sqlcommand = new SqlCeCommand(); sqlconnection.Open(); sqlcommand.Connection = sqlconnection; sqlcommand.CommandText = (@"UPDATE ItemStock_Info SET Quantity =@qun WHERE [Item_Number]='"+ textBox1.Text +"'"); sqlcommand.Parameters.Add("@qun", qun); Coding for Insert data 11 Years Ago by ashita08 … cmd; conn = new SqlConnection("Server=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.MDF;Trusted_Connection=True;User … Re: C# ASP.net Update Data into a SQL server database 11 Years Ago by raya bp SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString); conn.open(); Re: ExecuteNonQuery: Connection property has not been initialized. 11 Years Ago by pugilist_arcane SqlConnection sc = new SqlConnection("Data Source = Destroyed-pc; Initial Catalog = school; Integrated Security = … Trace: [SqlException (0x80131904): Incorrect syntax near '@Email'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950522 System.Data.SqlClient.SqlInternalConnection… Re: How to connect to a wamp server database using C# 2010? 13 Years Ago by Momerath SqlConnection is for connection to SQL Server, not MySQL. Either use [URL="http://msdn.microsoft.com/en-us/library/system.data.oledb.aspx"]OleDB[/URL], [URL="http://msdn.microsoft.com/en-us/library/system.data.odbc.aspx"]ODBC[/URL], or [URL="http://www.mysql.com/products/connector/"]Connector/Net[/URL] Re: Two Tables In DataGridView 13 Years Ago by SUNFARMS …\DBMYC.mdf;Integrated Security=True;User Instance=True"; SqlConnection con = new SqlConnection(connstr); //SqlCommand cmd = sqlConnection1.CreateCommand(); SqlCommand cmd = con.CreateCommand… Re: Procedure or Function has too many arguments specified 15 Years Ago by Elmo_loves_you SqlConnection myConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|DatabaseName.mdf;Integrated Security=… Re: Take BackUp of SQL server Database using C# 14 Years Ago by Ivan_86 SqlConnection connect; string con1 = @"Data Source=" + newForm.ServerName… newForm.ID + ";Password=" + newForm.Pass; connect = new SqlConnection(con1); connect.Open(); SqlCommand command; command = new SqlCommand(@"backup… Re: Create Database Connection in the C#.net 14 Years Ago by krisss sqlconnection cn=new sqlconnection(user id=sqlserver username ;password=sqlserver password;database=database name); cn.open(); Re: Create Database Connection in the C#.net 13 Years Ago by gowthamkannan SqlConnection sc=new SqlConnection(" user id=sa; password=system; database=login;"); sc.Open(); loaddata(); kriss I'm Gowtham i did try this code but im getting a error on cn.open() Re: Sample C# Windows Form Login Screen 13 Years Ago by nidhi18sep SqlConnection con = new SqlConnection(strConn); string strCmd = "select UserName, Password from Login where … Re: creating a register button for login 11 Years Ago by wen_cai SqlConnection conn = new SqlConnection("server=KISH;uid=sa;pwd=msde;database=logdb"); … Re: sample asp.net with c# sql database connection 10 Years Ago by shailendra.joshi.946 SqlConnection cn = new SqlConnection("server=localhost;database=Database name;trusted_connection=true"); cn.Open(); Re: C# error - Not all code paths return a value 10 Years Ago by rkskalyan SqlConnection con = new SqlConnection("Data Source=6;Initial Catalog=kalyan;User ID=sa;Password=***********"); Line 18: public string insertuserdetails(BEL objuserdetails) Line 19: { error 'DAL.insertuserdetails(BEL)': not all code paths return a value Re: web service 13 Years Ago by finito SQLConnection SQLCommand 'SqlConnection' is ambiguous in the namespace 'System.Data.SqlClient'. 15 Years Ago by sonia sardana … System.Data.SqlClient.I just create object of SqlConnection,But error is there- 'SqlConnection' is ambiguous in the namespace 'System.Data.SqlClient… System.Data.SqlClient Public Class Form1 Dim conn As New SqlConnection End Class [/code] Re: 'SqlConnection' is ambiguous in the namespace 'System.Data.SqlClient'. 15 Years Ago by sonia sardana ….Data.SqlClient(Direct Code)) , you get this error in VisualStudio: 'SqlConnection' is ambiguous in the namespace 'System.Data.SqlClient'. SqlConnection error index 0 in c# 7 Years Ago by Arian_1 …private void txtID_TextChanged(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection(connstring)) { /*if (String.IsNullOrEmpty(txtID.Text)) { MessageBox.Show… How to Dispose SqlConnection in C# 13 Years Ago by sachintha81 … = false; } public void DoSomeWork() { //Use SqlConnection } public void Dispose() { Dispose(true); GC.SuppressFinalize… Security = SSPI;"; hConnection = (new SqlConnection(stConnectionString)); } public SqlConnection Open() { hConnection.Open(); return hConnection; }… Re: How to Dispose SqlConnection in C# 13 Years Ago by hyperion … following for closing the connection cleanly. [CODE]System.Data.SqlClient.SqlConnection sqlConn = null; try { sqlConn = new System.Data.SqlClient….SqlConnection("connection string"); sqlConn.Open(); // Some other code goes … Re: How to Dispose SqlConnection in C# 13 Years Ago by Momerath And to simplify Hyperion's code, you can do this: [code]using(SqlConnection sqlConn = new SqlConnection("connection string")) { sqlConn.Open(); // Some other code goes here using sqlConn // ... }[/code] You can read more about it [URL="http://msdn.microsoft.com/en-us/library/yh598w02%28VS.80%29.aspx"]here[/URL]. Re: How to Dispose SqlConnection in C# 13 Years Ago by Momerath Don't worry about it, the SQLConnection object will handle the disposing of the unmanaged resources all by itself. connection string of SqlConnection 16 Years Ago by quintoncoert … the argument list for the connection string of the SqlConnection object's SqlConnection constructor. On various info sources the arg list for… Re: problem with sqlConnection object 14 Years Ago by Vivek_1986 … working properly. [COLOR="Green"]Public Conn As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security… Re: problem with sqlConnection object 14 Years Ago by kvprajapati … working properly. [COLOR="Green"]Public Conn As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security… problem with sqlConnection object 14 Years Ago by Vivek_1986 i'm creating an small application which uses sqlConnection for the purpose of connection to the database. but i'… Re: problem with sqlConnection object 14 Years Ago by jbisono Can you show more code, beacuse I do not see the connection object something like this [QUOTE]Dim conn as New System.Data.SqlClient.SqlConnection(ConnectionString)[/QUOTE] and then [QUOTE]conn.open()[/QUOTE] How to get Unique columns and Primary key constraints using SqlConnection.GetSchema() 14 Years Ago by waleed_cs2000 hi I have some code of ADO.net to dynamically detect the database schema, [B]what I need is how to get Unique columns constraints and Primary key constraints using SqlConnection GetSchema() method.[/B] thanks at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boo 10 Years Ago by mandar_palse …: 62 Line Number: 1 ------------------------------ Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection… Re: Coding for Insert data 11 Years Ago by sania khan …,Address,Contact_Person,Contact_Person_no) VALUES (@Customer_id,@Name,@Address,@Contact_Person,@Contact_Person_no) SqlConnection con = new SqlConnection("Server=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.MDF;Trusted_Connection=True…