ASP.NET

Loop many records from database to many table

10-Nov-09 1:12

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);

This might help.

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

Re: Emailing html page

Ersan Ercek10-Nov-09 1:30

Ersan Ercek

10-Nov-09 1:30

good answer it seems exactly what I need.

thanks

LTMKH10-Nov-09 0:50

10-Nov-09 0:50

hello..I create project online exam with database sql server ...
For multiple question there are many answers for each one questions.
Example: question A have 5 answer
question B have 18 answer
I want to loop answers of question of A(id=1) to textBox: Ans1,Ans2,Ans3,...Ans10 according to number of answers..

Please help me..
thanks

Gamzun10-Nov-09 1:06

10-Nov-09 1:06

Use a group by query to get your data and use them accordingly.

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

LTMKH10-Nov-09 1:21

10-Nov-09 1:21

Thank to reply..
can u give me some example?

Gamzun10-Nov-09 2:58

10-Nov-09 2:58

what exactly you've done up til now?

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

LTMKH10-Nov-09 21:52

10-Nov-09 21:52

i'm not reach any result.

Shameel10-Nov-09 3:44

Shameel

10-Nov-09 3:44

CREATE TABLE Questions
(
    QuestionID int IDENTITY(1,1),
    QuestionText varchar(1000)
)

CREATE TABLE Answers
(
    AnswerID int IDENTITY(1,1),
    AnswerText varchar(1000),
    IsCorrectAnswer bit DEFAULT(0),
    QuestionID int
)


SELECT AnswerID, AnswerText
FROM Answers
WHERE (QuestionID = 1234)

LTMKH10-Nov-09 15:43

10-Nov-09 15:43

thanks for reply...
I don't need this TSQL.. but i want to apply this data that have selected to TextFields in webform...
I have 10 textfield of answer for the maximum 10 answers ,but the answer of question that we sellect could be 2,3,4,5,8...

Gamzun11-Nov-09 8:30

Pass a stream as a function parameter

11-Nov-09 8:30

Please correct your question, it's not clear.

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

Nagarajan.C10-Nov-09 0:47

Nagarajan.C

10-Nov-09 0:47

How to convert a string to stream and pass that stream to XMLElement function call

Re: Pass a stream as a function parameter

Shameel10-Nov-09 3:45

Shameel

10-Nov-09 3:45

Please be more specific. Your question is vague.

How we attached Multiple file for send mail.

lrsalunkhe9-Nov-09 23:57

lrsalunkhe

9-Nov-09 23:57

Respected,

How we attached Multiple file for send mail.

Thanks.

Re: How we attached Multiple file for send mail.

Gamzun10-Nov-09 0:21

add columns in gridview at runtime

10-Nov-09 0:21

Use MailAttachment class. Check this out ASP.NET email with multiple attachments[^]

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

streaming video files

yrishi9-Nov-09 23:38

yrishi

9-Nov-09 23:38

Hello everyone,
I want to put streaming video files(.wmv) on my server and want to access them from client computers. Also don't know how to access these videos from my web application.
Please help me on this
thanks in advance

Regards
Yrisi

datatable

mylogics9-Nov-09 23:37

mylogics

9-Nov-09 23:37

hiii m using datatable.i want to get the row by its id.
for this i have coded:

public decimal GetItemTotal() 
{ 
    int intcounter = 0; 
    decimal decRunningTotal = default(decimal); 
    DataTable dt = Session("Cart"); 
    DataRow dr = default(DataRow); 
    for (intcounter = 0; intcounter <= dt.Rows.Count - 1; intcounter++) { 
        dr = dt.Rows(intcounter); 
        decRunningTotal += (dr("ItemPrice") * dr("ItemQty")); 
    } 
    return decRunningTotal; 
}

its gives error on line:
dr=dt.Rows(intcounter)
error:rows is property but is used like method.
tell me hw can i retrive row by its id.

Re: datatable

padmanabhan N9-Nov-09 23:46

padmanabhan N

9-Nov-09 23:46

mylogics wrote:
dr = dt.Rows(intcounter);

try using like this,

dr = dt.Rows[intcounter];

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

anilaabc9-Nov-09 22:01

9-Nov-09 22:01

I m adding columns in gridview at runtime ,but these get lost at postbask,I have to reload all at postback ,how should i add columns that it donot disappear at postback.

Christian Graus9-Nov-09 22:10

Christian Graus

9-Nov-09 22:10

Are you binding to your data source in postback ? If you are, you'll lose your columns. If not, I'd have thought not.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

anilaabc9-Nov-09 22:17

9-Nov-09 22:17

if i do like
if(!ispostback)
{
gridview.datasource=datasource;
}
all the columns disappear,I have to reload/bind with datasource at postback.
I m adding columns in grid like this
private void AddColumns()
{
TemplateField bfield = new TemplateField();

try
{
HeaderText = GetGlobalResourceObject("ViewQuotations", col.ColumnName).ToString(); //Assigns the name of the column in the lable.
}
catch (Exception e)
{
HeaderText = col.ColumnName;
}
//Initalize the DataField value.
bfield.HeaderTemplate = new GridViewTemplate(ListItemType.Header, col.ColumnName, HeaderText);

//Initialize the HeaderText field value.

bfield.ItemTemplate = new GridViewTemplate(ListItemType.Item, col.ColumnName);

//Add the newly created bound field to the GridView.

grdViewEqpCard.Columns.Add(bfield);
}

Gamzun9-Nov-09 23:36

9-Nov-09 23:36

Your datasource should be dynamic. Make your datasourse (datatable, dataset) at runtime and bind it to the grid (grid should've it's property AutoGeneratedColumns to True)

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

anilaabc10-Nov-09 0:24

10-Nov-09 0:24

I need to add some links and radiobuttons in gridview columns at gridview row bound event ,that 's the reason i myself adding fields in gridview,not setting its autogenerate columns ot true

Gamzun10-Nov-09 0:55

10-Nov-09 0:55

You can still add link through rowdatabound event.

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

anilaabc10-Nov-09 0:59