ASP.NET

6-Aug-07 20:58

Hi i am trying to display data on a gridview but it doesn't display anything and it doesn't give any error.
here is my code

string conString = @"Data Source=jakes;Initial Catalog=K2;User ID=sa";
SqlConnection conProcinst = new SqlConnection(conString);
conProcinst.Open();
DataSet dsProcinst = new DataSet();
SqlDataAdapter daProcinst = new SqlDataAdapter();
try
{

SqlCommand cmdProcinst = new SqlCommand("SELECT * FROM _ProcInst", conProcinst);
daProcinst.SelectCommand = cmdProcinst;

daProcinst.Fill(dsProcinst,"_ProcInst");

GridView1.DataSource = dsProcInst;
GridView1.DataBind();
GridView1.AllowPaging = true;

Mamphekgo

gauthee6-Aug-07 21:04

gauthee

6-Aug-07 21:04

Check whether you query returns any records!
Check your connection string. provide password too

gauthee

Mamphekgo Bahula6-Aug-07 21:28

6-Aug-07 21:28

My connection string is fine because i copied.

Mamphekgo

Mamphekgo Bahula6-Aug-07 21:29

6-Aug-07 21:29

now it gives me this error.
The data source does not support server-side data paging

Mamphekgo

sulabh20206-Aug-07 21:04

sulabh2020

6-Aug-07 21:04

Mamphekgo wrote:string conString = @"Data Source=jakes;Initial Catalog=K2;User ID=sa";

I think in ur constring database server name is missing, try to include the server name.

Hello Forum
Always be in touch to help about the topic ASP.NET

VanithaVasu6-Aug-07 21:58

6-Aug-07 21:58

Will @ symbol comes in the connction string.

Mostly the @ symbol will be used for c# coding while giving long path of the source file where two slashes should be used.
Eg: in C# - @"C:/Myfolder/DBname"; or we can write "C://Myfolder//DBname";

Check without using the @ symbol.

VanithaVasu

Sonia Gupta6-Aug-07 21:25

Sonia Gupta

6-Aug-07 21:25

is there any diffeence between database/initial catalog

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Mamphekgo Bahula6-Aug-07 21:45

6-Aug-07 21:45

no is the samething

Mamphekgo

N a v a n e e t h6-Aug-07 22:48

Maintain values of Dynamic Dropdownlists in datagrid

6-Aug-07 22:48

mamphekgojakes wrote:
i am trying to display data on a gridview but it doesn't display anything and it doesn't give any error.
here is my code

1. Is your select query returning values in query analyzer ?
2. What is your page size ? Try commenting the allow paging line.
3. Put break point and ensure your dataset contains rows.

My Website | Ask smart questions

VanithaVasu6-Aug-07 20:46

Re: Maintain values of Dynamic Dropdownlists in datagrid

6-Aug-07 20:46

I am having two image buttoms - One is ADD button and another is Delete Button, and two dropdownlists one with project names and another ddl with task names of the particular project.
1.) I click the project and onSelectedIndexchanged of project i get the task names and from the tasks i select one task.
2.) Now i want to add new row to the datagrid and when i add i create a row dynamically.
But the values in the previous rows disappear. How do i maintain the selected values of the controls during runtime even if i add aor delete rows.

Can u please help me to find out the solution.

VanithaVasu

gauthee6-Aug-07 20:54

gauthee

6-Aug-07 20:54

Check when your grid is being filled!
Normally binding values to datagrid would be done in the pageload and when it is not post back.

gauthee

Re: Maintain values of Dynamic Dropdownlists in datagrid

VanithaVasu6-Aug-07 21:20

Re: Maintain values of Dynamic Dropdownlists in datagrid

6-Aug-07 21:20

I have filled my grid and i have written my code after post back only.
here is my code

if(e.Item.ItemType==ListItemType.Item)
{
if(Flag==true)
{
DropDownList drop=(DropDownList)e.Item.FindControl("dd1");
drop.SelectedValue=ddlSelectText;
cmd1=new OleDbCommand("select ptTask from Tasks where ptId="+taskid+"",con);
}
else
{
cmd1=new OleDbCommand("select ptTask from Tasks where ptId=1",con);

}
con.Open();
rd1=cmd1.ExecuteReader();
while(rd1.Read())
{
ddltasks.Add(rd1.GetValue(0).ToString());
}
con.Close();
if(Flag==true)
{
DropDownList tasklist=(DropDownList)e.Item.FindControl("dd2");
tasklist.DataSource=ddltasks;
tasklist.DataBind();
}
This is my code where i have written in datagrid_ItemBinding.Also this is the page load also. But when i add a new row i get the new row but i didnt get any value which i have set for my previous row.

I should get the value be maintained.
What should i do?

VanithaVasu

N a v a n e e t h6-Aug-07 22:37

6-Aug-07 22:37

VanithaVasu wrote:
Now i want to add new row to the datagrid and when i add i create a row dynamically.
But the values in the previous rows disappear. How do i maintain the selected values of the controls during runtime even if i add aor delete rows.

To understand your problem you need to be familiar about how ASPX page works and ASP.NET page lifecycle. MSDN is having good articles regarding this.

Regarding your problem, You are not getting previous values when new row added because, ASP.NET is not maintaining viewstate for your control. This is happening because you are creating dynamic columns somewhere after Init event. When an ASPX page processes, it will store viewstates in Init event. So whatever dynamic controls created after this event won't maintain viewstate.

To solve your problem, try creating the rows in page_init event. Remember when you create controls in init event, no need to check isPostBack

My Website | Ask smart questions

Authentication class

N a v a n e e t h6-Aug-07 20:37

6-Aug-07 20:37

It's a repost. I tried different combinations with the problem. But I couldn't find out where I am going wrong.

I created a class which checks session and redirects to login page. My class looks like this. This class inherits Page class to get access to session object.

public class CAuthentication:System.Web.UI.page
{
   public CAuthentication()
   {
      if ( Session["login"] == null )
         Response.Redirect("expired.aspx");
   }
}

My ASPX.CS looks like

public partial class MyPage:CAuthentication
{
   //Pageload goes here
}

This is not working. I am getting error "session can't be used inside a class". What is wrong here ? Normally codebehind file used to inherit System.Web.UI.Page, Instead of this I inherited this in my CAuthentication class. Where I am going wrong ?

My Website | Ask smart questions

Re: Authentication class

VanithaVasu6-Aug-07 21:09

6-Aug-07 21:09

you dont have to inherit CAuthentication class instead let it be System.Web.UI.Page . You have to assign the session value as null in the session_start ,in the Global .asax.cs file . And also u have to assign the values in the page_load where it can be processed when the session is not null.

VanithaVasu

Re: Authentication class

N a v a n e e t h6-Aug-07 22:26

Re: CheckBox in a DataGrid?

6-Aug-07 22:26

VanithaVasu wrote:
You have to assign the session value as null in the session_start ,in the Global .asax.cs file

What do you mean ?

I think you are telling to check session null in each page load. right ? To avoid that I have written this one.

My Website | Ask smart questions

CheckBox in a DataGrid?

chand106-Aug-07 20:27

chand10

6-Aug-07 20:27

Hi

In my application I got two columns,one is for Serial No. other one is for CheckBox.
I have get value from DataBase and fill into this DataGrid,for Serial No. I have Interger column in DataGrid and for CheckBox Tinyint.For CheckBox column in DataGrid values r 0 and 1.

My problem is that I have to get both the values simultaneously, if the value in CheckBox column is 1 then the CheckBox in the DataGrid should check,if it is 0 it should uncheck.

How can I get Serial No. in one column and checking of CheckBoxes in another.

What shuold I use for Getting values from DataBase; DataReader or DataSet

Plz suggest me an example.

I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison

Thank u
Chandu

N a v a n e e t h6-Aug-07 20:43