Re: Create a custom control(dropdownlist populating Datagrid or Table of records) - ASP.NET Discussion Boards

First Prev Next

Re: rating.

suparichit6-Jul-07 1:41

suparichit

6-Jul-07 1:41

thanks..i have stored my rate in database
------------------------------------------

x = rbtnRating.SelectedItem.ToString();
switch (x)
{
case "Excellent":
strRate = "5";
break;
case "Good":
strRate = "4";
break;
case "Average":
strRate = "3";
break;
case "Bad":
strRate = "2";
break;
case "Terrible":
strRate = "1";
break;
}
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["KMSConnectionString"]);
con.Open();
string str = "insert into Rating(Rate,Authorname,Replies,QId) values('" + strRate + "','" + btnName.Text + "','" + lblReply.Text + "' ,'" + btnSno.Text + "' )";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(str, con);
da.Fill(ds);

but in retriving the database
------------------------------

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["KMSConnectionString"]);
con.Open();
string sto = "select rate from rating where Authorname='" + btnName + "'";
DataSet ds1 = new DataSet();
SqlCommand com = new SqlCommand(sto, con);
String str3 = com.ExecuteNonQuery().ToString();

SqlDataAdapter da1 = new SqlDataAdapter(sto, con);
da1.Fill(ds1);
int countC = ds1.Tables[0].Rows.Count;
if (countC != 0)
{
for (int j = 0; j < countC; j++)
{

str3 += str3;

total = ((Convert.ToInt16(str3)) / (5 * countC));//here is my problem
}
}
Label1.Text = total.ToString();

harika

Re: rating.

Sathesh Sakthivel6-Jul-07 1:45

Sathesh Sakthivel

6-Jul-07 1:45

what problem it says?

Regards,

Satips. Rose | [Rose]

Re: rating.

suparichit6-Jul-07 2:07

suparichit

6-Jul-07 2:07

thers is a problem in binding the data to the label.could u please check the retriving code rating.

harika

how to retrive file from database

suparichit6-Jul-07 0:52

suparichit

6-Jul-07 0:52

code to download file from sqlserver in asp.net using c#

harika

Re: how to retrive file from database

Sathesh Sakthivel6-Jul-07 0:55

Sathesh Sakthivel

6-Jul-07 0:55

we cannot do your homework.

Regards,

Satips. Rose | [Rose]

Re: how to retrive file from database

Tarik Guney6-Jul-07 5:20

Tarik Guney

6-Jul-07 5:20

why would you try to find it in internet.?

Create a custom control(dropdownlist populating Datagrid or Table of records)

Jai Prakash Singh6-Jul-07 0:42

Jai Prakash Singh

6-Jul-07 0:42

Hello members,
I have to create a cutom control for dropdownlist which have records populated in a datagrid(display) or table format having different columns .When any one item of dropdownlist is selected then the selected value is displayed in an another textbox .
So i request you to please help me in this regard.

Thanks and Regards,
Jai

Re: Create a custom control(dropdownlist populating Datagrid or Table of records)

Parwej Ahamad6-Jul-07 0:50

Parwej Ahamad

6-Jul-07 0:50

Please clerify that, Textbox control used with custom control or on page where you use custom contlrol.

Parwej Ahamad
g_parwez@rediffmail.com

Re: Create a custom control(dropdownlist populating Datagrid or Table of records)

Jai Prakash Singh6-Jul-07 1:55

Jai Prakash Singh

6-Jul-07 1:55

I want to create a custom control which i have to use on an aspx page.
The custom control to be designed is Dropdownlist which when clicks shows a table of records.

Re: Create a custom control(dropdownlist populating Datagrid or Table of records)

Parwej Ahamad9-Jul-07 0:53

Parwej Ahamad

9-Jul-07 0:53

Ok,
(1) Create an event on u'r user control
(2) Raise this event on when select value from list box
(3) Trace this event on your Aspx page where u have to use user control.

Note: If you have to use C#, Then use Delegates for the trap the event

or

If you use VB.Net then u can use withevent .

Parwej Ahamad
g_parwez@rediffmail.com

A server control have not post back and have click event

Piyush Vardhan Singh6-Jul-07 0:42

Piyush Vardhan Singh

6-Jul-07 0:42

hi friends
i have a problem in web based cheating application where we using a chat window of

with scrollbar,i wana scroll bar always at bottom and i have done, but prblm is that i am using a hash table for coming msg.hash table work on btn click through javascript timer.prblm come when the btn click post back occerd so i wanat any control which not fierd postback . and have click event

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: A server control have not post back and have click event

Parwej Ahamad6-Jul-07 0:48

Parwej Ahamad

6-Jul-07 0:48

What's your need. You would to click client side or server side. And which kind of operation you would like to perform................

Parwej Ahamad
g.parwez@gmail.com

Re: A server control have not post back and have click event

Piyush Vardhan Singh6-Jul-07 0:57

Piyush Vardhan Singh

6-Jul-07 0:57

abe mane ek bttm li hai server side aur usko click kar raha hun javascript ke through jo ki bttm ke click pe hashtable se msg chat window pe jaye ga but jub bottom click hota hai page lode hota hai aur mai chahata hun ki page na lode ho aur ye asp.net me hai main mudda ye ki jab hash table se msg chat windo pe jaye to page lode na ho chae jis tarike se

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: A server control have not post back and have click event

Sathesh Sakthivel6-Jul-07 0:59

Sathesh Sakthivel

6-Jul-07 0:59

please learn English and use english here.

Regards,

Satips. Rose | [Rose]

Re: A server control have not post back and have click event

Piyush Vardhan Singh6-Jul-07 1:11

Piyush Vardhan Singh

6-Jul-07 1:11

hey man(Satips) this msg not for u. i am talking to my friends ok minde ur own bussiness ok

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Re: A server control have not post back and have click event

Parwej Ahamad6-Jul-07 2:00

Parwej Ahamad

6-Jul-07 2:00

Hold the Hashtable in session and then get the hashtable in javascript on click of button, client side.
And set the data in chat window.

Parwej Ahamad
g_parwez@rediffmail.com

Re: A server control have not post back and have click event

Tirthadip6-Jul-07 1:02

Tirthadip

6-Jul-07 1:02

you can have a HTML button control...but what you actually need????.....
there DropDownList(and other controls) which has a click event and you can handle the postback also...but will it serve your need???

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

Re: A server control have not post back and have click event

Piyush Vardhan Singh6-Jul-07 1:23

Piyush Vardhan Singh

6-Jul-07 1:23

hi Tirthadip
but on html control we con't use hash table because we con' write vb code on html control

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Export to Excel Problem [modified]

Jay_se6-Jul-07 0:37

Jay_se

6-Jul-07 0:37

I used the below code to Export my gridview to excel. I have paging set to true. I am facing 2 problems. (1)Error: RegisterForEventValidation can only be called during Render(). This error got resolved when I turned the EventValidation to false. This could be a security risk. Can u help me with this? (2) After the 1st problem is resolved temporarily, the next problem is that the entire DataSet doesn't get exported. Only the current page gets exported. I need paging, so is there a way where I can get the entire DataSet which is bound to the gridview control exported to excel . Please help....Let me know if you need any of my code snippet. Thanks..

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=Test.xls");
Response.Charset = "";

Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

GridView1.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());
Response.End()

I have got the Idea from here[^] for my Qn. #1

-- modified at 7:44 Friday 6th July, 2007

Jey

Re: Export to Excel Problem

DKalepu6-Jul-07 0:53

DKalepu

6-Jul-07 0:53

Did u use VerifyRenderingInServerForm() ??

Re: Export to Excel Problem

Jay_se6-Jul-07 0:58

Jay_se

6-Jul-07 0:58

1) I have already tried that one.

public override void VerifyRenderingInServerForm(Control control)
{
}

2) Tried like below also.

//Create a form to contain the grid

HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htmlWrite);

Regards,

Jay Smile | :)