ASP.NET

Connection String Error In C# Code RSS

7 replies

Last post Nov 22, 2012 04:45 AM by afastars

‹ Previous Thread|Next Thread ›

afastars

Member

52 Points

221 Posts

Connection String Error In C# Code

Nov 20, 2012 12:41 AM|LINK

currently i develop one logIn page by using c# code, the code below is a from vb.net code, i convert it into c#, now i don't either

the code below is correct or not, i got an error on this part below

mySQLConnection.ConnectionString = ConfigurationManager.ConnectionStrings["default"].ConnectionString;

the error is "object does not contain a defination for connectionString and no extension method ConnectionString"

below is my code, need help from expertise here, i'm new in c# code:

using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;




public partial class AdminLogIn : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        object mySQLConnection = new SqlConnection();
        mySQLConnection.ConnectionString = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
        //Try

        mySQLConnection.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = mySQLConnection;
        object adminname = txtid.Text;
        object adminpass = txtpass.Text;
        object KelasSelian = drpkelas.SelectedValue;

        cmd.CommandText = "select * from AdminLogIn where AdminName=@adminname and AdminPass=@adminpass";
        //cmd.CommandText = "select * from MaklumatGuru where UserName=@username and Password=@password"
        cmd.Parameters.AddWithValue("username", adminname);
        cmd.Parameters.AddWithValue("password", adminpass);
       
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {

            Session["username"] = adminname;
            Response.Redirect("RequestSupport.aspx");
        }
        else
        {
            
            lblerror.Visible = true;
            lblerror.Text = "Sila Semak Id,Katalaluan Atau Kelas Selian Anda";

        }

       
    }
}

Edited by afastars on Nov 20, 2012 12:41 AM
Edited by afastars on Nov 20, 2012 12:43 AM

- Reply
sahibas25

Member

147 Points

36 Posts

Re: Connection String Error In C# Code

Nov 20, 2012 02:43 AM|LINK

Use MySqlConnection instead of SqlConnection, Go through the below link,

http://dotnetstar.blogspot.com/2008/04/connectoraclesql-server-mysqlaccess.html

For using MySqlConnection, you need add reference to your application.
- Reply
afastars

Member

52 Points

221 Posts

Re: Connection String Error In C# Code

Nov 20, 2012 04:33 AM|LINK

hi sahibas25

i think you confius already..i'm not to use mysql...

it just a name actually..i'm using MS database 2008, need help
- Edited by afastars on Nov 20, 2012 04:38 AM
- Reply
sahibas25

Member

147 Points

36 Posts

Re: Connection String Error In C# Code

Nov 20, 2012 04:39 AM|LINK

No problem.. u can use OleDBProvider, OleDBConnection for MS Access\

Connection string look like this,

Provider=Microsoft.jet.OLEDB.4.0;Data Source=C:\sample.mdb

And you have to use,

using System.Data.OleDb;

Classes are,

OleDBConnection

OleDBDataAdapter

REFER the below link,

http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx
- Edited by sahibas25 on Nov 20, 2012 04:41 AM
- Reply
Decker Dong ...

All-Star

118619 Points

18779 Posts
Re: Connection String Error In C# Code

Nov 21, 2012 12:26 AM|LINK
afastars
```
object mySQLConnection = new SqlConnection();
```
Hello,

Problem is here——you cannot use "object" because "object" is every class's father——and it has no method of "Connection".

Solution：
```
SqlConnection mySQLConnection = new SqlConnection();
```
- Marked as answer by afastars on Nov 22, 2012 04:43 AM
- Reply
sravanisrav

Member

470 Points

107 Posts

Re: Connection String Error In C# Code

Nov 21, 2012 11:00 AM|LINK

Instead of using object Mysql=new SqlConnection();

use SqlConnection MySql=new SqlConnection();

It solves your error because it is clear that object does not contain definition for ConnectionString.

Mark as answer,if my post helps you..

Thanks & Regards
Sravani
- Marked as answer by afastars on Nov 22, 2012 04:42 AM
- Reply
Keyur Shah

Participant

1002 Points

278 Posts
Re: Connection String Error In C# Code

Nov 21, 2012 11:09 AM|LINK
Use like following
```
SqlConnection mySQLConnection = new SqlConnection();
        mySQLConnection = ConfigurationManager.ConnectionStrings["default"].ConnectionString;
```
Try and Try You will Success..!!
- Marked as answer by afastars on Nov 22, 2012 04:42 AM
- Reply
afastars

Member

52 Points

221 Posts

Re: Connection String Error In C# Code

Nov 22, 2012 04:45 AM|LINK

hi Decker Dong, sravanisrav, Keyur Shah

all of you resolve my problem....really happy can work with expertise...thanks a lot for reply..