|
Hi, As my requirement is i want to bind data to the dropdownlist in the gridview control. when iam doing this iam getting an error. "Cannot implicit convert Type 'string' to 'int'", "Only assignment, call, increment, decrement, and new object expressions can be used as a statement",and "Cannot apply indexing with [] to an expression of type 'method group'". Please help me...My code is as follows..
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = GetDataSet().Tables[0];
GridView1.DataBind();
}
private DataSet GetDataSet()
{
string connectionString = "user id=sa;password=victory;database=Northwind;server=INDUS-SERVER";
string query = "SELECT p.CategoryID, p.ProductID, p.ProductName, c.CategoryID, c.CategoryName from Products p,Categories c where p.CategoryID=c.CategoryID and c.CategoryID<2";
SqlConnection newConnection = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter(query, newConnection);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable myDataTable = new DataTable();
DataColumn productIDColumn = new DataColumn("ProductID");
DataColumn productNameColumn = new DataColumn("ProductName");
myDataTable.Columns.Add(productIDColumn);
myDataTable.Columns.Add(productNameColumn);
DataSet ds = new DataSet();
ds = GetDataSet();
int categoryID = 0;
string exp = string.Empty;
if (e.Row.RowType == DataControlRowType.DataRow)
{
categoryID = Int32.Parse(e.Row.Cells[0].Text);
exp = "CategoryID=" + categoryID;
DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownList1");
DataRow[] rows = ds.Tables[0].Select(exp);
foreach(DataRow roe in rows)
{
DataRow newRow = myDataTable.NewRow();
newRow["ProductID"] = rows["ProductID"];
newRow["ProductName"] = rows["ProductName"];
myDataTable.Rows.Add[newRow];
}
ddl.DataSource = myDataTable;
ddl.DataValueField = "ProductName";
ddl.DataValueField = "ProductID";
ddl.DataBind();
}
}
}
|
|
|
|
|
Can you tell me on which line your getting the Error ?
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Iam getting the error with the following lines...
DataRow newRow = myDataTable.NewRow();
newRow["ProductID"] = rows["ProductID"];
newRow["ProductName"] = rows["ProductName"];
myDataTable.Rows.Add[newRow];
|
|
|
|
|
I noticed that the Column "ProductID" (DataColumn productIDColumn = new DataColumn("ProductID") did not specify the Data type.
I think your data base returning ProductID as int type.
So you can resolve this prob lem in two way
(1) newRow["ProductID"] = rows["ProductID"].ToString();
OR
(2)Also specify the Data type as int, When you are creating the column
DataColumn productIDColumn = new DataColumn("ProductID")
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Still iam getting the same error even if i do the things whatever you said..please any further suggestions..
|
|
|
|
|
Even i tried your solution then also iam getting the same error..Please any further suggestions...
|
|
|
|
|
Can you post here modified code which i have suggested to you ?
Mark as bold where you are still getting the problem and also post error messages.
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Hi,
I am using RegisterStartupScript in a user control but it is not running the code.
Can you do this from a user control?
msg = "Invalid date entered for 'to' field."
script = "<script>"
script += "alert(""" & msg & """);"
script += "</script>"
Me.Page.RegisterStartupScript("script", script)
rotsey
|
|
|
|
|
Try this One:
msg = "Invalid date entered for 'to' field."
script = ""
script += <b>"alert('" & msg & "');"</b>
script += ""
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
|
hi want set some values in web.config, so that i can access it in all pages
say, color=red
how can i set that in webconfig and access in any of my webpage
|
|
|
|
|
use Appsetting in the webConfig
<appSettings>
<add key="MHASSANF" value="Programmer"/>
</appSettings>
|
|
|
|
|
how to access it in every webpage
|
|
|
|
|
|
<asp:gridview id="GridView1" runat="server" width="225px" gridlines="None" autogeneratecolumns="False" onrowcommand="GridView1_RowCommand" ><br="" mode="hold"> <columns>
<asp:templatefield>
<itemtemplate>
<asp:image id="Image1" imageurl="<%# Eval(" imagee")%"="">' runat="server" Width="20" Height="12"/>;
<asp:linkbutton id="lblink1" runat="server" font-overline="false" text="<%# Eval(" category")%&"="">' CommandArgument='<%# DataBinder.Eval(Container.DataItem, "category") %>;' Font-Size="10" Font-Names="Arial" CommandName="Click><asp:linkbutton>>
<asp:bulletedlist bulletstyle="Square" id="bullet" runat="server" datatextfield="subcategory" font-bold="true" font-names="Arial" font-size="12px">&
i want to display the bulletlist after the link button..
but i store the subcategory in one table and category will be stored in another table pls help me...
|
|
|
|
|
Where u want to display bulletlist ?
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
if i click any one of the category the bulletlist of the sub category display below the category.....
|
|
|
|
|
(1) Use commandName
CommandName="CategoryClick instead of Click
(2)Set Gridview attribute:
<asp:gridview id="CustomersGridView"
onrowcommand="CustomersGridView_RowCommand".....
(3)Add below method in Code behind file:
void CustomersGridView_RowCommand(Object sender, GridViewCommandEventArgs e)
{
if(e.CommandName=="CategoryClick")
{
string Category = e.CommandArgument;
}
}
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
but i used two table ... one table used for store category and another table used for store subcategory
That only i cannot display the record in one gridview
|
|
|
|
|
Execute Query for Sub Category and then bind your bulletlist on Row command event which was i have already post.
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Do you think you could EVER give a message a title other than "Question?"
You don't use the code tags.
READ THE FORUM GUIDELINES
|
|
|
|
|
hai friends
in a page i m checking whether user is valid or not thru the database
if user is not a valid then i m redirecting the user to login page
here i m gettin a error msg like this
"Thread was being aborted"
and then it is showing the login page
how to over come this problem
plz help me
i searched a lot in google but i didnt get it.............
thanks in advance
vijay
|
|
|
|
|
I think you using Try Catch block in Aspx code behind file and you have written Response.Redirect(..) method in Try and Catch Block.
If problem is like above stated then use
Response.Redirect("page.aspx",true);
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
Like , i can select top 10 records , how can i select last 10 records .
I used the following query , but did not work.
select top 10 columnname from tablename order by columnname desc
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
i think this is because of your "order"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
