ASP.NET

2-Mar-09 23:35

HI!

I do not know how to populate my GridView with stored procedure I have this code but it doesn't works she returned result or error message

public void BindData()
   {
       SqlConnection myConnection = new SqlConnection(ConnectionString);

       SqlCommand myCommand = new SqlCommand("PS_NV2", myConnection);
       myCommand.CommandType = CommandType.StoredProcedure;
       SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
       DataSet ds = new DataSet();
       myAdapter.Fill(ds, "TAble");
       myConnection.Open();
       myCommand.ExecuteNonQuery();
       GridView2.DataSource = ds;
       try
       {
          GridView2.DataBind();
       }
       catch
       {
           GridView2.PageIndex = -1;
           GridView2.DataBind();
       }
       myConnection.Close();

correct me please.Thanks

Satish Mahapatra2-Mar-09 23:56

Satish Mahapatra

2-Mar-09 23:56

execute the executenonquery before putting into adapter.

foryou3-Mar-09 0:50

3-Mar-09 0:50

Thank you Satish Mahapatra.

it doesn't works Frown | :(

this code works fine for a datagrid but not for the GridView

I do not know if the error can come from here
for datagrid i have DataGrid1.CurrentPageIndex = 0;
I have replaced by : GridView2.PageIndex =0 ;
thanks.

Satish Mahapatra3-Mar-09 0:57

Satish Mahapatra

3-Mar-09 0:57

can u send me whole code and where exactly ur getting the error with error description.

foryou3-Mar-09 1:22

3-Mar-09 1:22

I have no erreur no message erreur if i click sur the button I havent result.
my code c#:

using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
<br />
 private void Page_Load(object sender, System.EventArgs e)<br />
    {<br />
    }<br />
    public void BindData()<br />
    {<br />
        SqlConnection myConnection = new SqlConnection(ConnectionString);<br />
        SqlCommand myCommand = new SqlCommand("PS_NV2", myConnection);<br />
        myCommand.CommandType = CommandType.StoredProcedure;<br />
        SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);<br />
        DataSet ds = new DataSet();<br />
        myAdapter.Fill(ds, "table");<br />
        myConnection.Open();<br />
        myCommand.ExecuteNonQuery();<br />
        GridView2.DataSource = ds;<br />
        try<br />
        {<br />
            GridView2.DataBind();<br />
        }<br />
        catch<br />
        {<br />
            GridView2.PageIndex = 0;<br />
            GridView2.DataBind();<br />
        }<br />
        myConnection.Close();<br />
<br />
    }<br />
    private string ConnectionString<br />
    {<br />
        get<br />
        {<br />
string connectionString = (@"Data Source=.\SQLEXPRESS;UID=sa;Password=**3*;Initial Catalog=mybd");<br />
<br />
            return connectionString;<br />
        }<br />
    }<br />
protected void GridView2_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)<br />
    {<br />
        Response.Write(e.NewSelectedIndex);    <br />
<br />
    }<br />
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)<br />
    {<br />
        GridViewRow row = GridView2.SelectedRow;<br />
<br />
        TextBox4.Text = row.Cells[2].Text;<br />
<br />
    }<br />
    protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)<br />
    {<br />
        GridView2.EditIndex = e.NewEditIndex;<br />
        BindData();<br />
    }<br />
<br />
    protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)<br />
    {<br />
        GridView2.EditIndex = -1;<br />
        BindData();<br />
    }<br />
<br />
<br />
    protected void Button1_Click1(object sender, EventArgs e)<br />
    {<br />
        BindData();<br />
        GridView2.Visible = true;<br />
    }<br />
}<br />

<asp:gridview id="GridView2" runat="server" allowpaging="True" autogeneratecolumns="False" xmlns:asp="#unknown"><br />
                         DataKeyNames="c1" OnRowCancelingEdit="GridView2_RowCancelingEdit"<br />
                         OnRowEditing="GridView2_RowEditing"  OnSelectedIndexChanged="GridView2_SelectedIndexChanged"<br />
                         OnSelectedIndexChanging="GridView2_SelectedIndexChanging" Style="left: -214px;<br />
                         position: relative; top: 82px"><br />
                         <selectedrowstyle backcolor="Yellow" /><br />
                         <columns><br />
                             <asp:templatefield headertext="c1"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id0" runat="server" text="<%# Bind("c1") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id01" runat="server" text="<%# Bind("c1") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <asp:templatefield headertext="c22"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id1" runat="server" text="<%# Bind("c2") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id11" runat="server" text="<%# Bind("c2") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <asp:templatefield headertext="c33"><br />
                                 <edititemtemplate><br />
                                     <asp:textbox id="id2" runat="server" text="<%# Bind("c3") %>"></asp:textbox><br />
                                 </edititemtemplate><br />
                                 <itemtemplate><br />
                                     <asp:label id="id21" runat="server" text="<%# Bind("c3") %>"></asp:label><br />
                                 </itemtemplate><br />
                             </asp:templatefield><br />
                             <br />
                             <br />
                             <asp:commandfield showeditbutton="True" showselectbutton="True" /><br />
                         </columns><br />
                     </asp:gridview>

thanks

Satish Mahapatra3-Mar-09 1:33

Satish Mahapatra

3-Mar-09 1:33

i told u to put that executenonquery statement before putting into adaptare.now u just debug the code and see in the binddata method what it returns in the dataset and tell me.

foryou3-Mar-09 2:05

comparig password with the password in database

3-Mar-09 2:05

Thank you Satish Mahapatra it works I forgot a field in my stored procedure.

rosae6192-Mar-09 21:30

rosae619

2-Mar-09 21:30

Dear sir/madam
I have designed a login page where a user can enter,user name and password.The program can compare the password from database and can verify.The program is ok for a single user.
But when we have multiple user then i got the problem.The problem is that how can we know the specific user have logged in by comparing the password with database.And after comparing the password,how can we generate the name of the user stored in database in a new page..

waiting for the reply..

Re: comparig password with the password in database

Christian Graus2-Mar-09 21:35

Re: comparig password with the password in database

2-Mar-09 21:35

You can add a column to your database telling you a user is currently logged in.

rosae619 wrote:
how can we generate the name of the user stored in database in a new page..

Store it in the session.

I'd recommend buying a book on ASP.NET and web development.

Christian Graus

Driven to the arms of OSX by Vista.

rosae6192-Mar-09 22:23

rosae619

2-Mar-09 22:23

hi
thanx for the help..
here i am a bit new to ASP.NET,and i am trying to develop a web page in ASP.NET using c#.since i am new to this field,can you help me about the session(i am new to the session) and database stuffs..
waiting for the reply

comparing password with the password in database

sudheera p3-Mar-09 0:29

sudheera p

3-Mar-09 0:29

Hi,
assign the user name which logged in to session like this,
session["username"]=txt_username.Text

Re: comparig password with the password in database

Christian Graus3-Mar-09 9:18

3-Mar-09 9:18

I would recommend you buy a book on ASP.NET and read it. If you're doing paid work, stop it, and you should be ashamed. If you're teaching yourself, you should slow down and work through a book rather than try to do something that you could only do very badly given your obvious lack of experience. You need to learn how to do it first, even if your code works, I expect it's far from production quality at this point.

Christian Graus

Driven to the arms of OSX by Vista.

Grid view?

Karthick_gc2-Mar-09 21:12

Karthick_gc

2-Mar-09 21:12

Hi, In my project i used a gridview. I fill the details using Databind() method. And i want to format some detail using Html coding of the Grid view. They r working.

But during Runtime, the Datas are displayed twice both from html coding and Databind() method. How to avoid this?

I want to display only from Html coding? Is there is any code to fetch datas from Html?

Christian Graus2-Mar-09 21:13

2-Mar-09 21:13

Your best bet nearly always is using databinding. You can use runat="server" to interact with html elements, but I doubt that's what you want to do.

Perhaps if you posted your code we could point out what's wrong with it.

Christian Graus

Driven to the arms of OSX by Vista.

Karthick_gc2-Mar-09 21:29

Karthick_gc

2-Mar-09 21:29

In C# i write this code for produce datas?

protected void lnkview_Click(object sender, EventArgs e)
{
view.Visible = true;
add.Visible = false;
try
{
con.Open();
com = new SqlCommand("select *from hotjob", con);
rd = com.ExecuteReader();
view1.DataSource = rd;
view1.DataBind();
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

But i want some of the datas to appear in Link button. So i format it in the Html Coding.

<asp:gridview id="view1" runat="server" cellpadding="4" forecolor="#333333" gridlines="None" xmlns:asp="#unknown">
<footerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<rowstyle backcolor="#EFF3FB">
<editrowstyle backcolor="#2461BF">
<selectedrowstyle backcolor="#D1DDF1" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#2461BF" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White">
<columns> <asp:templatefield headertext="Job-ID" headerstyle-horizontalalign="Center">
<itemtemplate>
<asp:label id="lblId" runat="server" text="<%# Bind(" jid")="" %>"="">

<asp:templatefield headertext="Title" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:label id="lbltit" runat="server" text="<%# Bind(" title")="" %>"="">

<asp:templatefield headertext="Description" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:label id="lbldes" runat="server" text="<%# Bind(" description")="" %>"="">

<asp:templatefield headertext="Qualification" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:label id="lblqua" runat="server" text="<%# Bind(" qualification")="" %>"="">

<asp:templatefield headertext="Vacancies" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:label id="lblvac" runat="server" text="<%# Bind(" vac")="" %>"="">

<asp:templatefield headertext="Location" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:label id="lblloc" runat="server" text="<%# Bind(" location")="" %>"="">

<asp:templatefield headertext="Mail-ID" headerstyle-horizontalalign="Center">

<itemtemplate>
<asp:linkbutton id="lblmail" runat="server" text="<%# Bind(" mail")="" %>"="">

<asp:commandfield headertext="Delete" showdeletebutton="True" showheader="True">

This is the full code. It is working but datas display twice. I want to display only the Datas from Html.

Christian Graus2-Mar-09 21:33

2-Mar-09 21:33

Ah - add AutoGenerateColumns="false" to your grid view, by default it adds your templated columns AND generates one for each column in your data source.

Christian Graus

Driven to the arms of OSX by Vista.

Karthick_gc2-Mar-09 21:36

Karthick_gc

2-Mar-09 21:36

Hi, thanks very much. Its working.

[Message Deleted]

aratireddy2-Mar-09 21:08

aratireddy

2-Mar-09 21:08

[Message Deleted]

Re: Error

Christian Graus2-Mar-09 21:12