.net

Question

how to connect to db

Dipankar Biswas · Answer

hi.. Oledb... Imports System.Windows.Forms Imports System.Data.OleDb connectin: Public ConnString As String = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Arise english exam\Demo\Arise english exam\arise_english_exam.accdb;Persist Security Info=False Public conn As New OleDbConnection Private Sub new_user() Try 'Dim sqlquery As New OleDb.OleDbCommand conn.ConnectionString = ConnString If conn.State = ConnectionState.Closed Then conn.Open() End If Dim sqlquery As String = insert into new_user_table (user_nameuser_passworduser_email)  &  values(@username@userpass@usermail)  Dim sqlcommand As New OleDbCommand With sqlcommand .CommandText = sqlquery .Connection = conn .Parameters.AddWithValue(@username txt_new_uname.Text) .Parameters.AddWithValue(@userpass txt_new_upass.Text) .Parameters.AddWithValue(@usermail txt_new_umail.Text) .ExecuteNonQuery() End With Catch ex As Exception MessageBox.Show(ex.Message) End Try conn.Close() End Sub SqlClient Dim conn As New SqlClient.SqlConnection conn = New SqlClient.SqlConnection conn.ConnectionString = Data Source=Localhost; Initial catalog=win_exam_system; Integrated security=true Private Sub RefreshData() If Not conn.State = ConnectionState.Open Then conn.Open() End If 'ds.Tables.Add(dt) Dim da As New SqlDataAdapter(select Date_TimeSubject_1Subject_2Subject_3Subject_4Subject_5 from Qus_upload_tbl  conn) Dim dt As New DataTable da.Fill(dt) Me.DataGridView1.DataSource = dt conn.Close() End Sub

Adinarayana Reddy Jc · Answer

hi kartheek try this one. http://adidotnettotal.blogspot.in/2013/03/registration-form-in-aspnet-using.html

Vincent Maverick Durano · Answer

how to connect to db This is a very generic question and can easily be found at google by doing a simple search. Also what database do you want to connect with? Which development platform? windows? web? What data access do you want to use for connecting to your database?

Khargesh Rajput · Answer

http://www.c-sharpcorner.com/uploadfile/201fc1/introduction-to-sql/ http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Riddhi Valecha · Answer

The connection strings will be different... Refer - http://www.dofactory.com/reference/connection-strings Hope this helps !

Manoj Bhoir · Answer

Hi You will get so many example on Internet to connect your applicaion with database. Sample Code : using System; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender EventArgs e) { string connetionString = null; SqlConnection cnn ; connetionString = Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password cnn = new SqlConnection(connetionString); try { cnn.Open(); MessageBox.Show (Connection Open ! ); cnn.Close(); } catch (Exception ex) { MessageBox.Show(Can not open connection ! ); } } } } Please check these link : How to connect SQL Database to your C# program beginner's tutorial http://www.codeproject.com/Articles/823854/How-to-connect-SQL-Database-to-your-Csharp-program C# SQL Server Connection http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm For more info about Conections strings for different types of Database http://www.connectionstrings.com/