ASP.NET

VenkataRamana.Gali18-Sep-07 18:23

VenkataRamana.Gali

18-Sep-07 18:23

aviod DB trips, i.e., very first time retrieve the data & store in dataset. user this only one dataset.

as per the u r requirement, avoid the database trips.

Ramana

RanjithLogics18-Sep-07 18:27

18-Sep-07 18:27

Hii

Thanx for the reply.
The gridview is associated with an sqldatasource. As per your reply, is it making the gridview slow ??

Ranjith Stephen

VenkataRamana.Gali18-Sep-07 18:30

VenkataRamana.Gali

18-Sep-07 18:30

use dataset instead of sqldatasource, defenetly i will imporve ur performance

Ramana

RanjithLogics18-Sep-07 18:42

Generate CSV File from database

18-Sep-07 18:42

OK.. thanks I will try that way..

And also I found another thing.
I am showing the gridview in a div with scroll bars. When I turned the paging option on in gridview ,it helped the situation very much and I found the operations being faster. Smile | :)

Anyways thank you very much for your precious opinion ..

Ranjith Stephen

C#Coudou18-Sep-07 15:10

C#Coudou

18-Sep-07 15:10

I have an application that retreives records from a database, which will be displayed in a datagridview. Moreover, I would also generate a csv file from that query and allow user to save it. I have a code that save a csv file but I don`t have a code on how to generate a csv from database records. How will I do that? Is any body here who can help me. Much appreciated if somebody will give me a link or code.
Smile | :)

Thanks in advance,
C#Coudou;)

******************************
I just want to
know everything

Re: Generate CSV File from database

VenkataRamana.Gali18-Sep-07 18:18

VenkataRamana.Gali

18-Sep-07 18:18

can u give the DataBase table structure ?

Ramana

Use javascript in User control

kjosh18-Sep-07 15:07

kjosh

18-Sep-07 15:07

Hi,

I developed one user control which contain 3 check boxes. Now Checkbox3 is enabled only Checkbo1 and 2 are checked. I want to enable the Checkbox3 by using the JavaScript by checking whether checkbo1 and 2 checked or not.

Can anyone help me on this.

Thanks in advance

Re: Use javascript in User control

Christian Graus18-Sep-07 15:40

Christian Graus

18-Sep-07 15:40

This is javascrpt 101, the main thing is you need to write script that creates variables that contain the client side names of the checkboxes.

What else do you need help with ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Session Time Out in ASP.NET

kumswa18-Sep-07 14:08

kumswa

18-Sep-07 14:08

Hi all,

Pls does anyone here have an idea how I can reduce the default session timeout in my web application? (I am using dotnetnuke)

Thanks!

Re: Session Time Out in ASP.NET

RanjithLogics18-Sep-07 16:49

Re: Session Time Out in ASP.NET

18-Sep-07 16:49

In web.config

<system.web>
<sessionState timeout="30"/>
</system.web>

Ranjith Stephen

kumswa18-Sep-07 21:30

kumswa

18-Sep-07 21:30

Thanks!

help me plz

tamertolba18-Sep-07 14:01

tamertolba

18-Sep-07 14:01

I just need ASP registration page with MS Access database and dsn file
but put the mdb file in folder name data
thanks for all

bbbbginer

Re: help me plz

Not Active18-Sep-07 14:19

Not Active

18-Sep-07 14:19

Read "How to get an answer to your question"

only two letters away from being an asset

Re: help me plz

Saksida Bojan18-Sep-07 21:05

Saksida Bojan

18-Sep-07 21:05

You probably would have to modify connection string, to point it to mdb file.

Setting the Checkbox text

kjosh18-Sep-07 13:48

kjosh

18-Sep-07 13:48

Hi,

I have an array like this:

string[3] arr;

arr[0]="ck1";

arr[1]="ck2";, arr[2]= "ck3"..

Now In my aspx page I have 3 checkboxes. Now I want to set the Checkbox text from the array arr values (for the first checbox text as arr[0]. like this) instead of setting the text while declaring the checkboxes.

Thanks in advance.

Re: Setting the Checkbox text

RanjithLogics18-Sep-07 16:53

18-Sep-07 16:53

there is a read/write property "Text" for checkbox. So what is the problem is setting the text ?
You can set it like
checkbox1.Text = arr[0].ToString()

Ranjith Stephen

Custom Control

Saksida Bojan18-Sep-07 11:46

Saksida Bojan

18-Sep-07 11:46

When creating custom control, does it need to be in diffrent project as ddl?

If no then how can i use custom control (Class of custom control is in App_Code folder), within same project.

Re: Custom Control

m v ramana18-Sep-07 19:53

m v ramana

18-Sep-07 19:53

//Hi I am new for Asp.net
// try this
//give a namespace(Ex:ExtendedCalendrControl) for your control(ex:ViewCalender class) in the App_Code folder
namespace ExtendedCalendrControl
{

public class ViewCalender : System.Web.UI.WebControls.Calendar
{
//code
}
}

//register the namespace
<%@ Register Namespace="ExtendedCalendrControl" TagPrefix="viewCal" %>
<viewcal:viewcalender id="viewCalnder" selectionmode="None" width="400">

ramana

Re: Custom Control

Saksida Bojan18-Sep-07 21:03

Saksida Bojan

18-Sep-07 21:03

I have already tryied this.

I coudnt Register, Even if i used src. I wanted to use class.cs not class.aspx. If i woud link aspx, it probably would work, but i want class.cs

gridview [modified]

newbieAl18-Sep-07 10:37

newbieAl

18-Sep-07 10:37

I can't seem to get to display the results from a gridview. The code compiles but it only shows 'no records' when I display the webpage. Any help would be greatly appreciated. I am thinking that maybe the information for 'typename' and 'dataojecttypename' are incorrect. What exactly should these two contain?

Here is my code in part:

[DataObjectMethod(DataObjectMethodType.Select)]
public static List<userdata> getAllUsers()
{
MySqlCommand cmd = new MySqlCommand();
DB_Connection conn = new DB_Connection();

try
{
cmd.Connection = (MySqlConnection)conn.DBConnect();

cmd.CommandText = "getAllUsers";
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
MySqlDataReader dr;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List<userdata> userList = new List<userdata>();
while (dr.Read())
{
UserData user = new UserData();
user.UserID = Convert.ToString(dr["User_ID"]);
user.UserLastName = Convert.ToString(dr["User_Last_Name"]);
user.UserFirstName = Convert.ToString(dr["User_First_Name"]);

}
dr.Close();
return userList;

<asp:objectdatasource id="ObData" runat="server" typename="users"
="" oldvaluesparameterformatstring="original_{0}" selectmethod="getAllUsers" dataobjecttypename="userdata">

<asp:gridview id="GridView1" action="databind" runat="server" datasourceid="ObData" autogeneratecolumns="False" emptydatatext="<b>No Records</b>" allowpaging="True" datekeynames="User_Id">
<columns><asp:boundfield datafield="User_Id" headertext="User_Id" sortexpression="User_Id">
<asp:boundfield datafield="User_Last_Name" headertext="LastName" sortexpression="User_Last_Name">
<asp:boundfield datafield="User_First_Name" headertext="FirstName" sortexpression="User_First_Name">

ChrisKo18-Sep-07 11:14

ChrisKo

18-Sep-07 11:14

Your method returns userList, which has only been instantiated and has not been initialized. You might want to put some values in that list for the datagrid to bind to. I'm assuming thats what you're binding the datagrid with.

Next time, please put the code in <pre></pre> tags to make it easier to read.

newbieAl18-Sep-07 12:36

newbieAl

18-Sep-07 12:36

ok, thanks for the tip.

pmarfleet18-Sep-07 11:45

pmarfleet

18-Sep-07 11:45

List userList = new List();

You create an instance of a List object but you don't add any items to it.

while (dr.Read())
{
  UserData user = new UserData();
  user.UserID = Convert.ToString(dr["User_ID"]);
  user.UserLastName = Convert.ToString(dr["User_Last_Name"]);
  user.UserFirstName = Convert.ToString(dr["User_First_Name"]);
}

For each iteration of the loop, you create a new UserData object and populate it with data from the current record returned by the DataReader. However you don't do anything with each UserData object. After each iteration of the loop the UserData object will go out of scope and be lost. You should add these objects to some sort of collection data structure if you want to retain them.

Regards

Paul