gridview won't populate with custom connection string and custom datasource

Question

i've set up an userdefined connection string and now trying to populate a gridview using that,breakpoint shows connection string's fine..also no error,but surprisingly datatable is n't receiving any value..although data exists...what have i done wrong??

Default3.Aspx:

<td colspan="2" align="center">
  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">       
  </asp:GridView>     
</td>

Default3.Aspx.Cs:

protected void Page_Load(object sender, EventArgs e)
{
    string con = OracleDatabase.connection();
    String SelectCommand = "select * from EMP";

    OracleDataAdapter adp = new OracleDataAdapter(SelectCommand, con);
    DataTable dt = new DataTable();
    adp.Fill(dt);
    GridView1.DataSource = dt;
    GridView1.DataBind();
    /* 
    OracleDatabase.gridpopulate(SelectCommand, GridView1);
    GridView1.DataSource = OracleDatabase.gridpopulate(SelectCommand);
    GridView1.DataBind();
    */ 
    //i tried doing this by writting a function At class file also
}

Class file:

public static string connection()
{
    oradb = ConfigurationManager.ConnectionStrings["ConnectionString"]
           .ConnectionString;
    string str = "Data Source="+db+";User ID="+userid+";Password="+password+";";
    oradb = String.Concat(oradb, str);        
    con = new OracleConnection(oradb);
    con.Open();
    return oradb;
}

/*(function for gridpopulate)
public static void gridpopulate(string SelectCommand,GridView grid1)
{
    string con =(ConfigurationManager.ConnectionStrings["ConnectionString"]
                 .ConnectionString);
    con = String.Concat(con, str);
    adp = new OracleDataAdapter(SelectCommand,con);
    DataTable dt = new DataTable();
    adp.Fill(dt);
    grid1.DataSource = dt;
    grid1.DataBind();
    //return dt;         
 }
*/

Why did you do autogeneratecolumns=false? You either need to set that to true or add some markup defining your columns. — mason
– mason, Commented Feb 19, 2014 at 5:24
you sure the oradb = String.Concat(oradb, str); results into correct connection string??? — Manish Mishra
– Manish Mishra, Commented Feb 19, 2014 at 5:31

Keshavdas M · Accepted Answer · 2014-02-19 05:23:23Z

1

Try as per below, instead of returning connection string from function return Oracle Connection object and pass the same to Adapter.

OracleConnection con = OracleDatabase.connection();

public static OracleConnection connection()
{
 oradb =ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 string str = "Data Source="+db+";User ID="+userid+";Password="+password+";";
 oradb = String.Concat(oradb, str);        
 con = new OracleConnection(oradb);
 con.Open();
 return con;
}

answered Feb 19, 2014 at 5:23

Keshavdas M

7022 gold badges9 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2691165 Over a year ago

sorry to reply that the datatable still isn't receiving any data...y'r logic seems brilliant...but for some unknown reason it doesn't populate the grid...is it running @ y'r end??

Keshavdas M Over a year ago

Have you set AutoGenerateColumns = True ?? Please check

Collectives™ on Stack Overflow

gridview won't populate with custom connection string and custom datasource

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related