|
|
I am getting problem in searching. I am using SQL2005 and C#.net 2008. I have 6 text boxes to take input from user. input is depend upon user
either input for search in 1 textbox, either input in 2 or either input in 3 or in all
i am looking how can i handle it. i am not using data set in this application at all.
i have stproc for all other operations. please let me know how can i handle it.
thanks
|
|
|
|
|
how to handle what? getting input from a textbox?
I think you may need to re-write your problem here 
|
|
|
|
|
are you able to create a connection to the server and query a database?
you will need to build your query string dynamically based on the input from the user.
make sure you use parameters thou and not direct text appends
|
|
|
|
|
Well, what specifically are you having difficulty with? Writing the query? Writing the code to query the database? Writing a stored procedure? Figuring out how to pass the parameters? Something else?
|
|
|
|
|
sorry guys,
all done
thanks
|
|
|
|
|
Member 2842468 wrote: all done
But what was the problem? I am curious
|
|
|
|
|
Hi All,
I would like to create own tcp/ip header for my client in c# like raw and can be send with data, my application wants this kind of process for my client.
Can any one please help me out in this with example or code in c#.
Thanks n Regards
Ankur Shrivastava  
|
|
|
|
|
That's a very bad solution to an unknown problem. RAW packets can only be created by an admin level account since Windows XP Service Pack 2.
|
|
|
|
|
public partial class try1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
string query_ddl = "select range from DDLValue";
SqlDataAdapter da = new SqlDataAdapter(query_ddl, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds);
con.Close();
ddl_value.DataSource = ds;
ddl_value.DataTextField = "Range";
ddl_value.DataValueField = "Range";
ddl_value.DataBind();
}
protected void ddl_value_SelectedIndexChanged(object sender, EventArgs e)
{
createTextbox();
}
private void createTextbox()
{
string selectedValue = ddl_value.SelectedValue;
if (!string.IsNullOrEmpty(selectedValue))
{
int aSample = Convert.ToInt32(selectedValue);
for (int i = 0; i > aSample; i++)
{
TextBox txtbox = new TextBox();
txtbox.ID = "txt" + i.ToString();
Button1.Click += new EventHandler(Button1_Click);
PH1.Controls.Add(txtbox);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
}
How insert Data from Textbox at Button_click
|
|
|
|
|
At first glance there are several things wrong with this code.
1: you create several textbox controls but you don't set there location, so unless 'PH1' is a tablelayoutpanel or flowlayoutpanel all your textbox's will be shown on top off each other.
2: why add a new eventhandler to button1 for every textbox you create.
If button1 is created at designtime you don't need to add an eventhandler to it in code.
If button1 is created at runtime (off which there is no code here) adding it only once should be enough.
3: as to your question, the way you wrote it here you have 2 options.
Having a array variable (global) and adding all your textbox's to this array, then in button click event iterate this array.
Or iterate all the controls in 'PH1', check if there type is of the type textbox and get the text that way.
|
|
|
|
|
Can u Post Some code or Links
|
|
|
|
|
I knew this question was going to come.
Did you at least try to do anything I said?
I don't write c# so can't help you with that
But here is some vb.net code (easy to convert)
for each c as control in PH1.controls
if c.gettype.equals(gettype(textbox)) then
dim txt as textbox=c
dim textstring as string = txt.text 'now you have the text in the textbox
end if
next
modified on Wednesday, January 14, 2009 8:51 AM
|
|
|
|
|
Give Error at GetType?
How track the Dynamic id of textbox?
|
|
|
|
|
developer.ravish wrote: Give Error at GetType?
What's the error? please be more descriptive when asking questions.
developer.ravish wrote: How track the Dynamic id of textbox?
What do you mean by this. If you mean how can you just put 'txt1.text' in your code and get the text form that dynamicly created textbox, then you can't (well maybe with reflection but I don't know).
|
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string query_ddl = "Query";
SqlDataAdapter da = new SqlDataAdapter(query_ddl, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds);
con.Close();
ddl_value.DataSource = ds;
//ddl_value.DataTextField = "Range";
ddl_value.DataValueField = "Range";
ddl_value.DataBind();
ddl_value.Items.Insert(0, (new ListItem("Please Select Value", "0")));
}
}
protected void ddl_value_SelectedIndexChanged(object sender, EventArgs e)
{
createTextbox();
}
private void createTextbox()
{
TableRow tr = new TableRow();
TableCell tc = new TableCell();
string selectedValue = ddl_value.SelectedValue;
if (!string.IsNullOrEmpty(selectedValue))
{
int count = Convert.ToInt32(selectedValue.ToString());
for (int i = 0; i < count; i++)
{
tr = new TableRow();
tc = new TableCell();
TextBox txtbox = new TextBox();
txtbox.ID = "txt" + i.ToString();
tc.Controls.Add(txtbox);
tr.Cells.Add(tc);
tbl1.Rows.Add(tr);
tr = new TableRow();
tc = new TableCell();
TextBox txt_box = new TextBox();
txtbox.ID = "txt_" + i.ToString();
tc.Controls.Add(txt_box);
tr.Cells.Add(tc);
tbl2.Rows.Add(tr);
}
// tbl1.Rows.Add(tr);
}
}
Now on Button_Click i want to save Data From the Texboxes?
|
|
|
|
|
This is completely different than the first code you posted.
But basicly its the same, you'll have to go thru all the rows of tbl1 and tbl2.
Get the cell of that row(since you only have one column you should be able to get it very easy). That cell should then contain your textbox off which you can get the text.
pseudo code (vb.net sorry)
for each row as datarow in tbl1
dim txt as textbox = row.item(0).control(0)
dim data as string = txt.text
next
You'll have to adapt this code it is untested and from memory so...
|
|
|
|
|
|
Create an application that allows the user to enter the length for the three sides of a triangle as ints. The application should then determine whether the triangle is:
• A right triangle, two sides of the triangle form 90-degree angle
• An equilateral triangle, all sides of equal length
• Neither.
You must create a class to represent a triangle object and define the event handler for the Create Button. Define the necessary properties:
Constructor that take the length of the three sides of the triangle as arguments
Three properties that enable clients to access and modify the length of the three sides. If the user enters a negative value that side should be zero.
Tow features to determine whether the sides form a right triangle. The other an equilateral triangle only get accessor "read-only".
help to solve this program..please...please
|
|
|
|
|
I will!!
But first, build me a house that has:
- Four bedrooms
- A garage
- A beertender in every room
I are troll
|
|
|
|
|
Obvious homework questions don't go down well here. Be more specific, and show you've had a go first. You might get a useful an answer that way.
|
|
|
|
|
Sounds like an extract from an assignment brief lol
is it?
pretty basic stuff really. You know much c#?
|
|
|
|
|
Tell you what, as i feel in a helpful mode.
If you post at 12.30pm (My Time (in one hour))saying your still stuck, i will help you out with a bit of code. But give it a try yourself till then. its not too difficult for what you want to do
P.S are you doing a console app or a windows form or what?
|
|
|
|
|
Please don't do people's homework for them, not in its entireity anyway. They learn nothing, pass caourses, go out to work and the rest of us spend our life clearing up their mess!
|
|
|
|
|
As others have said, you have to do your own homework. If you don't, how do you expect to learn anything?
Provide the code you have written so far along with what you are stuck on and we will be only too glad to help you out.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
