ASP.NET

Re: Column wise paging in a Gridview

31-May-08 4:06

Did you try :-

GridView1.Columns[Col no..(1,2,..)].Visible=false;

on Page Load event

Parwej Ahamad
R & D with IIS 5.0/6.0

G. Mathu1-Jun-08 19:18

G. Mathu

1-Jun-08 19:18

sorry let me explain my scenrio, I have 2 type of display in dropdown as Horizontal and vertical. if select horizontal it is normal gridview but on selecting vertical, i'm converting Rows into column to get vertical display in Gridview, the datasource is dynamic dataset. so in this mode, i already tried the paging as like ur idea by assuming the Dropdown(page dropdown selecting 5 0r 10 etc...)value as i in a forloop, but i get an error..

The code i wrote was

for (i=0;i<=int.Parse(drppagelist.SelectedValue.ToString());i++)
{
GridView1.Column[i].Visible=True;
}

but error comes as value cannot be 0 or less than index range...

Re: Column wise paging in a Gridview

Parwej Ahamad2-Jun-08 6:43

insert datas from gridview to database using asp.net.+ c#

2-Jun-08 6:43

I understand your problem. Please follow up my previous post.

Dear, Right now you are facing a little bit logical issues like index of range, this is not a major problem just try it you will resolve it.

Parwej Ahamad
R & D with IIS 5.0/6.0

kushan31-May-08 1:34

kushan

31-May-08 1:34

In my from i use grid view .In that i add rows and values dynamically on button click.when i click the submit button all the row values must be insert in to database how can i do that.In grid i didnt use any template.I just add values in that.how can i find each row vaues and save to database.

How i can update GridView in web page when i edit or delete or insert a record in database?

Saba0231-May-08 1:26

Saba02

31-May-08 1:26

Hi all,

I have a gridview that when i select a row of gridview a detailview comes that i can edit or delete or insert a record in database.

but this changes not be shown in my gridview that time.
i should again run my program that these changes be shown in my gridview.

How i can update GridView in web page when i edit or delete or insert a record in database with detailview without re run?

Thank you,

Hoda

Re: How i can update GridView in web page when i edit or delete or insert a record in database?

Christian Graus31-May-08 1:27

Christian Graus

31-May-08 1:27

You should bind your data grid to it's data source in prerender, not in page load. Then, it will occur after any event handlers, and you should see the results.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

How to develope a webservice which automatically updates its ad(in window project) from a website

K V Sekhar31-May-08 0:40

K V Sekhar

31-May-08 0:40

Hi all...

I think my subject line not dat much clear...
Here is My Requirement:

*I hav windows project ..it displays ads in the masterform.. and also
*I hav webproject in dat user is going to add their adds(i mean de can register their ads in dis webproject)

Actually Client uses the Windows project.. when client is connected to internet and opens our website(our webproject) den we have to upload our ads which r registered in our webproject into ClientSystem(Window project) in place of ads(In masterform we r providing place for Displaying ads..AdRotator )..

How can i achieve this.. how can i solve dis by WebServices/WinodwsServices...

Plz..Help me in dis issue...I need ur suggestions....

Thanks in Advance.

Thanks&Regards,
kvsekhar

Re: How to develope a webservice which automatically updates its ad(in window project) from a website

Christian Graus31-May-08 1:26

Christian Graus

31-May-08 1:26

Please don't be doing de cross post in de different forums. Dat be annoying.

CP IGNORE

leckey31-May-08 4:45

leckey

31-May-08 4:45

Posted in THREE forums.

Shhhhh.....
http://craptasticnation.blogspot.com/[^]

DataBinding to DropDownList in GridView Error

Samiullah31-May-08 0:34

31-May-08 0:34

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();
}
}
}

Parwej Ahamad31-May-08 1:28

31-May-08 1:28

Can you tell me on which line your getting the Error ?

Parwej Ahamad
R & D with IIS 5.0/6.0

Samiullah31-May-08 2:08

31-May-08 2:08

Iam getting the error with the following lines...

DataRow newRow = myDataTable.NewRow();
newRow["ProductID"] = rows["ProductID"];
newRow["ProductName"] = rows["ProductName"];
myDataTable.Rows.Add[newRow];

Parwej Ahamad31-May-08 3:53

31-May-08 3:53

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

Samiullah3-Jun-08 0:32

3-Jun-08 0:32

Still iam getting the same error even if i do the things whatever you said..please any further suggestions..

Samiullah3-Jun-08 1:42

3-Jun-08 1:42

Even i tried your solution then also iam getting the same error..Please any further suggestions...

Parwej Ahamad3-Jun-08 7:16

RegisterStartupScript is user control

3-Jun-08 7:16

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

rotsey31-May-08 0:28

rotsey

31-May-08 0:28

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

Re: RegisterStartupScript is user control

Parwej Ahamad31-May-08 1:26