|
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
|
|
|
|
|
Thank to reply..
can u give me some example?
|
|
|
|
|
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
|
|
|
|
|
i'm not reach any result.
|
|
|
|
|
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)
|
|
|
|
|
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...
|
|
|
|
|
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
|
|
|
|
|
How to convert a string to stream and pass that stream to XMLElement function call
|
|
|
|
|
Please be more specific. Your question is vague.
|
|
|
|
|
Respected,
How we attached Multiple file for send mail.
Thanks.
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
mylogics wrote: dr = dt.Rows(intcounter);
try using like this,
dr = dt.Rows[intcounter];
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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);
}
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
I need to add a column having radio button list.
how will this i add then
|
|
|
|
|
plz help me, i need to do this urgent
|
|
|
|
|
in rowdatabound create an object of radiobutton and add it to the column you want.
Please don't forget to mark 'Good Answer', if you find it really a good one!
Kashif
|
|
|
|
|
Thank you ,I think autogenerate =true is the solution
|
|
|
|
|
I am working on LMS application and I have added a scorm course in my application.
|
|
|
|