|
Hi,
I'm just wondering if I'm on the write truck. this code is ment to look
for an ID number in the datagrid that matches the the ID number that is
in the textbox I created.
But it's not selecting neither is it showing me any error. could some
one help me please?
private void bttok_click(object sender, System.EventArgs e)
{
con.Open();
try
{
using (SqlCommand myCommand = new SqlCommand("select * from employee where txtname.text=@id",con))
{
SqlParameter myparam = new SqlParameter("@id",SqlDbType.Text);
myparam.Value=ID;
myCommand.Parameters.Add(myparam);
using (SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand))
{
DataSet ds = new DataSet();
myAdapter.Fill(ds);
datagrid1.DataSource=ds;
datagrid1.DataBind();
}
}
}
catch(Exception err)
{
err.ToString();
}
finally
{
con.Close();
}
}
|
|
|
|
|
It's not showing the error because you are catching it and discarding it. This is a very bad idea.
If you show the error message, you will see that you can not access a value from the table txtname as you haven't included the table in the query. I suspect that it's actually not a table at all, which would mean that the condition in the query doesn't make any sense at all.
---
Year happy = new Year(2007);
|
|
|
|
|
Thanks Guffa,
Actually the table is mentioned it's employee and txtname that is where I'm the user is supposed to put the ID number that is supposed to be compared to the ID in the datagrid so that the row can be selected.
Thanks.
|
|
|
|
|
nclauder wrote: Actually the table is mentioned it's employee
The table that I was talking about is "txtname". When you use "txtname.text" in the query, it means "the field text in the table txtname".
---
Year happy = new Year(2007);
|
|
|
|
|
Do you sugest I would have done it like this select * from isp_email.staff where @id="+txtname.Text,con);? If so I've tryed it but all in vain. when I Put the name in the textBox and press the button it does not select the row.
Thanks
-- modified at 7:41 Tuesday 9th January, 2007
|
|
|
|
|
Hi, maybe I post my question not on correct board bu plz forgive me...
In my asp.net 2.0 application toolbar of CrystalReportViewer1 control doesn't shows icons.
Shuld I install anything else or what is the problem?
here is the image[^]
Thanks and best regards
|
|
|
|
|
Hi All,
From the Popup window, I wish to return the Selected value to the control in my main page. (ASP.NET 2.0)
So I have passed the Control Name as refernce through QueryString. In the Click event I have fired the below code in C#. But, this script is NOT closing the popup window and assign the value to the control in the parent window.
Waht is the mistake with me?
String returnScript = "";
returnScript += "";
returnScript += "window.opener.document.all['";
returnScript += Request.QueryString["CtrlName"];
returnScript += "'].value = '";
returnScript += strSelectedDate;
returnScript += "';window.close();";
returnScript += "<" + "/" + "script>";
Page.ClientScript.RegisterStartupScript(this.GetType(),"key1", returnScript);
-- modified at 3:39 Tuesday 9th January, 2007
<div class="ForumSig">Regards,
<b>Jay</b>  </div>
|
|
|
|
|
Though I don't know what is wrong with the code, I know what could be. And if I'm wrong, my advice is still valid.
1. Don't use document.all. It only works in IE. Even if that's your target browser. Instead use document.getElementsById. And for this, make sure you pass Ctrl.ClientID to the Page.
|
|
|
|
|
how to validate textbox in datagrid if i didn't enter the value in textbox.i dont want to use requiredfeild validator.if press button it sholud show that value should be entered.plzz send me it is very urgent if any body knows it.
|
|
|
|
|
I think u can use javascript for this...
|
|
|
|
|
Dear all
i am making web application using asp.net ,C# (visual studio 2005) with sql2000.
In a web page there is listbox with multiple seelct option. i want to save all selected option of listbox
along with other web page infomation on Save button. What i am trying is first i save all selected item to array list
and then inserting it to the table.
i am assaigning to arraylist as
int count = 0;
string[] names = new string[10];
for (int i = 0; i < Listbox1.Items.Count; i++)
{
if (Listbox1.Items[i].Selected == true)
{
count++;
for (int j = 0; j < 7; j++)
{
names[count] = Listbox1.Items[i].Text;
//Response.Write(@names[j]);
break;
}
}
}
Is it a better approach. or any other way is there so that multiple selecting item can be fetched on save button .
please guide me
thank
regards
imran khan
|
|
|
|
|
Unfortunately the server is down, but here's what I know. I received an error when the page tried to access an Application[variable] that I believe was set earlier in the application.
This application worked in my dev environment, but doesn't work on the production server. One thread I had read mentioned that the background thread is ran as ASP_NET account. If that's the case, wouldn't this account still have access to Application[variable]???
I'm at my wits end. I wish the server wasn't down so I could do some more troubleshooting. Any ideas would be great...
|
|
|
|
|
Hi,
We have a folder on our LAN which is about 11GB in size.
I need to build a web interface to it which will allow users
to search the repository.
This is going to be an indexed based search, which means that
results will be dependent on the content of the files. This in
turn implies that we will need to index the contents first.
The filetypes are: office docs, pdf's and zips.
Any tools? frameworks? or suggestions regarding this?
I've heard of dotLucene, but when I tried it, the stupid tool
did nothing other than delete every file in the folder to be
indexed. Thank god I didn't try it on the actual LAN folder.
Please help. This is really urgent.
ASP - AJAX is SEXY. PERIOD.
|
|
|
|
|
i wana do "Changing Master Pages Dynamically in asp.net". one of my masters page code is
public partial class MasterPage : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
public partial class MasterPage2_master
}
}
but in linkbuttons control code error comes .and i m doing this from the tutorial
"http://www.exforsys.com/content/view/1627/354/1/0/"
can anyone check this tutorial and tel me the problem.
Chohan
|
|
|
|
|
The tutorial is bugged in some places, especially when writing the LinkButton_Click event handler. So here's what you have to do:
1. Add two master pages to your website, for example MasterPage1.master and MasterPage2.master. Edit them a you like, but make sure they contain the same number of ContentPlaceHolders.
2. Add a webform, for example Default.aspx, and make sure "Select master page" chechkbox is clicked.
3. When asked for the master page, select one from the earlier created ones.
4. Add two LinkButtons (or regular Buttons) to Default.aspx. Set the Text property as you like, and hook them up with Click event handlers.
5. In one of the Click event handlers write the following:
Session["Master"] = "~/MasterPage1.master";
Response.Redirect(Request.Url.ToString());
while in the other change "~/MasterPage1.master" to "~/MasterPage2.master".
6. Add the following to the page:
protected void Page_PreInit(object sender, EventArgs e)
{
if (Session["Master"] != null)
this.MasterPageFile = (string)Session["Master"];
}
Now run the web site, and test the functionality by clicking the LinkButtons.
|
|
|
|
|
Please can you tell me the path of Global Assembly Cache(GAC).
hi, can you please help me to clarify this doubt.
|
|
|
|
|
GAC path will be like this
C:\[windows root path]\assembly
In my case its
C:\WINDOWS\assembly
|
|
|
|
|
i used crystal report in vs2005. i work wirh c#and web application. count of my columns in repord are deffrent its count depended to database .how can i set the columns in crystal report?
can anybody help me???
|
|
|
|
|
Hi,
I have dynamicaly created a template Column at runtime. It works fine but
during postback it vanishes.
I have to retain the dyanamicaly added column during postback so what to do.....?
Thanks in Advance.............
Yuva
|
|
|
|
|
hi
i want to make a web application which can do some thing like send some emails on the specific time automatically without calling the application by any one means at specific time server automatically call that file and that sends the email
i didn't got any idea that how to do so can some guide me that how to do this
thanks in advance
regards
shezi
|
|
|
|
|
You are describing a "Windows Service[^]". This has nothing to do with Web Application and therefore ASP.NET is not relevant.
led mike
|
|
|
|
|
Actually i want my application to send birthday cards on the birth date of the member so i actually don't know what to call it exactly if u can explain some...... i m using asp.net (c#)
shezi
|
|
|
|
|
why we will give connection srting in web.config and please mention the code or syntax.
I Mohammed Abdul Nasar,my qualification is Msc(computer science),working in top mnc.
|
|
|
|
|
Hello all
I have a one doubt regarding the asp.net
1)when i try to open my asp.net project i am getting this error
visual studio .NET has detected that the specified web server is not
running ASP.NETversion 1.1. you will unable to run ASP.NET web
applications or services.
So kindly suggest to avoid this and open my project
hai all please clarify my doubts
|
|
|
|
|
You may have two versions of .NET framework.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
