ASP.NET

anilpal1-Apr-09 23:11

1-Apr-09 23:11

Hi,

Now there can 2 solution or may even more.

1. Take one public variable and assign column name on button click based on requirement
like

ID="picID" // button1
ID="UserID"// button2

or else

2. You can rename the column name of the either dataTable on run time like:

ds.Tables[0].Columns[0].ColumnName = "Abc";

feel free to ask

Regards
Anil Pal

TALHAKOSEN1-Apr-09 23:23

TALHAKOSEN

1-Apr-09 23:23

Thanks for your reply,

.aspx file
ItemTemplate
Label ID="Label1" runat="server" text=<%#Eval(ID)%>
ItemTemplate

.cs file

string ID; ------ how can i send this to item template, when i wrote like text=<%#Eval(ID)%> it gives error protected void Button1_Click(object sender, EventArgs e)
{
ID = "picID";
DataList1.DataSource = SqlDataSource1;
DataList1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
ID = "UserID";
DataList1.DataSource = SqlDataSource2;
DataList1.DataBind();
}

thanks for everything i have...

anilpal1-Apr-09 23:54

1-Apr-09 23:54

hi,

OK try another

Regards
Anil Pal

Create table in codebehind

TALHAKOSEN2-Apr-09 0:45

TALHAKOSEN

2-Apr-09 0:45

anyway thanks

thanks for everything i have...

saravanan051-Apr-09 22:50

saravanan05

1-Apr-09 22:50

hi friends

i need create tabele in codebehind how can i create it..

for example;

how can achive in code behind

Known Is Drop.Unknown Is Ocean

Abhijit Jana1-Apr-09 22:56

1-Apr-09 22:56

saravanan05 wrote:
hi friends

i need create tabele in codebehind how can i create it..

for example;

how can achive in code behind

Your given example is not coming properly. Which kind of table you want create ?

cheers,
Abhijit
CodeProject MVP

saravanan051-Apr-09 23:03

saravanan05

1-Apr-09 23:03

hi
i need to create like this:

i need to create in codebehind..

Known Is Drop.Unknown Is Ocean

anilpal1-Apr-09 23:06

1-Apr-09 23:06

hi,

Sorry dear but again its not displayed. If this is the image then send to
me at anil.bly@gmail.com

Or explain through text only.

Regards
Anil Pal

N a v a n e e t h1-Apr-09 23:06

N a v a n e e t h

1-Apr-09 23:06

Edit your post and use ignore HTML tags option. Poke tongue | ;-P

Navaneeth

How to use google | Ask smart questions

Abhijit Jana1-Apr-09 23:09

1-Apr-09 23:09

You have done the same mistake. before post please checked "Ignore HTML tags in this message (good for code snippets)" Check Box Wink | ;)

cheers,
Abhijit
CodeProject MVP

saravanan051-Apr-09 23:15

saravanan05

1-Apr-09 23:15

hi
i need to create table in code behind

<table>
<tr>
<td>
</td>
</tr>
</table>

Known Is Drop.Unknown Is Ocean

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay1-Apr-09 23:52

Colin Angus Mackay

1-Apr-09 23:52

You could place a literal control on the page. In the code behind write the code to generate the Table and assign the result to the Literal control's Text property.

anilpal1-Apr-09 23:59

1-Apr-09 23:59

hi,

You can also use HtmlTable, HtmltableCell. row ect class to create the table from code behind.

Regards
Anil Pal

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay2-Apr-09 0:52

Colin Angus Mackay

2-Apr-09 0:52

That would work. But the OP seemed to be indicating that he wanted to write the HTML directly. Either that or he thought we might not know what a table looked like in HTML.

problem after publishing on server

prateekfgiet1-Apr-09 22:38

prateekfgiet

1-Apr-09 22:38

i have a web page which issue product all products issue smoothly without error on local system but when i publish same page on server,and try to issue prodect(perticuler one product) gives error
error is
Input string was not in a correct format.
while code is for that perticular product
cmd.CommandText = "select * from total_stock where ptype='RJ-45 SIMPLE' ";
adp.Fill(ds, "ab");
foreach (DataRow dm in ds.Tables["ab"].Rows)
{
lblval.Text = dm["pqty"].ToString();
}
n = Convert.ToDouble(TextBox2.Text);
if(Convert.ToDouble(lblval.Text) < Convert.ToDouble(n))
{
Page.RegisterStartupScript("onClick", "<script
Language=JavaScript>alert('Please check the Stock !')</script>");

}
else
{
o = Convert.ToDouble(lblval.Text) - Convert.ToDouble(n);
lblval.Text = Convert.ToString(o);
con.Open();
cmd.CommandText = "update total_stock set pqty='" +
lblval.Text + "' where ptype='RJ-45 SIMPLE'";
cmd.ExecuteNonQuery();
con.Close();
//end
cmd.CommandText = "select * from material_issue";
adp.Fill(ds, "re");
dr = ds.Tables["re"].NewRow();
//cmd.CommandText = "select * from total_stock";
cb = new SqlCommandBuilder(adp);
adp.Update(ds.Tables["re"]);
dr = ds.Tables["re"].NewRow();

dr["ptypename"] = "RJ-45 SIMPLE";
dr["materialissue_date"] = DateTime.Now;
dr["issue_to"] = TextBox1.Text;
dr["entered_by"] = Label28.Text
dr["qty"] = TextBox2.Text;
dr["remarks"] = "ISSUE TO TECHNICIEAN";
ds.Tables["re"].Rows.Add(dr);
cmd.CommandText = "Select * from material_issue";
cb = new SqlCommandBuilder(adp);
adp.Update(ds.Tables["re"]);
Page.RegisterStartupScript("onClick", "<script
Language=JavaScript>alert('RJ-45 is Issued !')</script>");
}

Re: problem after publishing on server

Abhijit Jana1-Apr-09 22:59

dropdownlist with other option

1-Apr-09 22:59

prateekfgiet wrote:
I have a web page which issue product all products issue smoothly without error on local system but when i publish same page on server,and try to issue prodect(perticuler one product) gives error
error is

Please do not cross post. You have asked same question just few hours back. please continue with the same thread.

cheers,
Abhijit
CodeProject MVP

prateekfgiet1-Apr-09 22:37

prateekfgiet

1-Apr-09 22:37

i have dropdown list which contain the name of states and last option is other if user select the option other,then a textbox will apper on page and value save from textbox,how i will do? thanx in advance

anilpal1-Apr-09 23:02

1-Apr-09 23:02

hi,

you can do code to display the textbox on select index change event of dropdownlist.

like:

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if(DropDownList1.SelectedValue=="others")
{
// Code to display the textbox
}
}

feel to free ask

Regards
Anil Pal

Abhijit Jana1-Apr-09 23:06

1-Apr-09 23:06

prateekfgiet wrote:
i have dropdown list which contain the name of states and last option is other if user select the option other,then a textbox will apper on page and value save from textbox,how i will do? thanx in advance

Did you tried to implement it ? What problem are you faceing?

When user select the other from Dropdown lost, you can check it on Dropdown list selectedIndexChanged event, and on that time just make visible Textbox. And then save the data when you want. For unnecessry postback avoiding you can use Java script for that also.

cheers,
Abhijit
CodeProject MVP

prateekfgiet1-Apr-09 23:20

prateekfgiet

1-Apr-09 23:20

i m doing in this manner
protected void DropDownList6_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList6.SelectedValue == "OTHER")
{
TextBox12.Visible = true;
}
}
and for saving in database
if (DropDownList6.SelectedValue == "OTHER")
{
dr["remarks"] = TextBox12.Text;
}
else
{
dr["remarks"] = DropDownList6.SelectedValue.ToString();
}
but the problem is that textbox will not apper on selection of others and null value saved at database