hi,
i am using two pages, the first page contains the gridview control which i select one record means that job id of particular record move to second page through querystring. But in second page i have a design like form of textboxes and dropdownboxes.This control are filled depend on the job id which i select from first page.
i try the below mentioned code, it throw an error like "Invalid attempt to read when no data is present."
first.aspx
<body>
<form id="form1" runat="server">
<div>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Default4.aspx">New</asp:HyperLink>
<asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="~/Default4.aspx">Open</asp:HyperLink><br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" CellPadding="4" DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None" PageSize="5" AllowSorting="True" Caption="Book Details" CaptionAlign="Top" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" DataKeyNames="Job_ID">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:CommandField/>
<asp:HyperLinkField DataNavigateUrlFields="Job_ID" DataNavigateUrlFormatString="Default4.aspx?JID={0}" Text="Open" />
<asp:HyperLinkField DataNavigateUrlFields="Job_ID" DataNavigateUrlFormatString="Default4.aspx?JID={0}" Text="Create batch" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pmgConnectionString %>"
SelectCommand="SELECT [Job_ID], [Project_Manager], [Book_Name], [Job_Source], [Work_Type], [Software], [Job_Type], [Complexity], [Priority], [Publisher] FROM [book]"></asp:SqlDataSource>
</div>
</form>
</body>
secondpage.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
string cid;
cid= Request.QueryString["JID"];
Response.Write(cid);
SqlConnection dbcon = new SqlConnection("Data source=localhost;initial catalog=pmg;integrated security=true");
//dbcon.Open();
SqlCommand co2 = new SqlCommand("select book_name from book where job_id= '"+cid+"' ", dbcon);
co2.Connection.Open();
SqlDataReader dr = co2.ExecuteReader();
//co2.ExecuteNonQuery();
//rd = co2.ExecuteReader();
if (dr.HasRows == true)
{
TextBox1.Text =dr["book_name"].ToString();
}
dr.Close();
dbcon.Close();
}
thanks in advance,
murugavel
|
| Author: Mexi Renjith Mamman 12 Aug 2008 | Member Level: Gold | Rating:  Points: 3 |
Your code seems to be correct.
Please check the QueryString value in the second page with your DB ,ie, chk with DB that you are getting corrosponding details with the JobId which you have passed or got through QueryString.
Check the QueryString as
if (Request.QueryString["JID"]!= null)
{
int cid = Convert.toInt32(Request.QueryString["JID"]);
}
|