|
Hi All,
I have one requirement i have one search text box and i have 10000 entry into the database. so when when user write any value to text box it should search in database and all value should come in below like drop down.
how to do this which control of ajax we need to use?
Thanks,
amit
|
|
|
|
|
|
|
hi ,iam using asp.net with c#
iam trying to return sum of amount between the date values by using the same querry in sql it it working perfect . but when iam using in asp.net with c# ,it is returning zero value .....can you correct my code which helps me
SqlCommand cmdallltransactions = new SqlCommand("SELECT SUM(Amount) FROM AllTransactions WHERE TransDate BETWEEN '"+ txtfrom.Text +"' and'" + txtto.Text + "'and (TransCode <> 0) and BranchKey=" + Convert.ToInt32(Session["BranchKey"]) + "GROUP by BranchKey", con);
con.Open();
txttotal.Text = Convert.ToString(Convert.ToInt64(cmdallltransactions.ExecuteScalar()));
con.Close();
|
|
|
|
|
Check if your session return null value or correct value, put space after and before AND conditions,GROUP BY condition :
developerit wrote: SqlCommand cmdallltransactions = new SqlCommand("SELECT SUM(Amount) FROM AllTransactions WHERE TransDate BETWEEN '"+ txtfrom.Text +"' and '" + txtto.Text + "' and (TransCode <> 0) and BranchKey=" + Convert.ToInt32(Session["BranchKey"]) + " GROUP by BranchKey", con);
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
hi, every thing is ok, it is returning session values also,i have checked with break ponts.but at final it is returning zero . even there is already values are present in database it is returning zero.
can u correct the code which helps me.
|
|
|
|
|
Hi...
I hope the problem is with the date which the query gets from the text field. can u debug and tell me in what format the date is returned from the text field..
Thanks and regards,
Tash
|
|
|
|
|
i have debug and absorb that text box field is taking date in mm/dd/yyyy format
|
|
|
|
|
Hi..
Do one thing debug the code, add a 'quick watch' on the query and copy the query from the 'quick watch' window and paste in on sql analyzer and run the query and let me know.
Thanks and Regards,
Tash
|
|
|
|
|
hi, i have done debugging very carefully and copy and paste the querry in sql analyzer but in sql it is returning data . and in asp.net it is returning zero.
|
|
|
|
|
|
i have check this post also but the result iam getting the same zero.
i have checked the connection string,session value every thing is fine
i have run the same querry in sql analyzer also it is working fine and result is displayed but in asp.net it is returning zero
can give suggestion what to do next
|
|
|
|
|
|
hi
iam having a treeview where the sample structure is like this ...
cabinet under cabinet there are folders and under folders there are some documents.now i want that documents to move from one folder to another folder using drag and drop ...how can i perform this functionality.
Thanks in advance
|
|
|
|
|
|
Hi,
I am using datalist with radiobutton and (label which is set to visibility false) in itemtemplate.On mouseover of radiobutton in datalist i want to display corresponding label text in floating div.If there are 4 radiobuttons i have to display corresponding labels in div on onmouseover.Is there any way to do it?.Please help....
Thanks
Dwarak
|
|
|
|
|
Hi,
public static void ExportDataSetToExcel(DataSet ds, string filename)
{
HttpResponse response = HttpContext.Current.Response;
// first let's clean up the response.object
response.Clear();
response.Charset = "";
// set the response mime type for excel
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "\"");
// create a string writer
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// instantiate a datagrid
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[0];
dg.DataBind(); dg.RenderControl(htw);
response.Write(sw.ToString());
response.End();
}
}
}
This is the code which i am using to export data in excel format.But in excel it wont allow '0'(zero) number .ie for zipcode it wont allow to save 0978678 coz zero is starting element
but it will allow 890453 or 506889 like that. i just want one field (here zipcode field) as text field. Is there any way to do that?
Known is a drop, unknown is an ocean
|
|
|
|
|
I turned off Dynamic ports in VS2008 for a project because I need to configure an external app with a url to my application so the port needs to be the same every time.
The problem is now VS returns an error "Unable to launch the ASP.NET Development Server. Port 'n' is in use."
How can I get my system to release this port so it can be reserved and used only by my website?
|
|
|
|
|
|
Hi..
I want to access ConfigurationManager.AppSettings["xxx"] value to session_end event of global.asx.
Is it possible ? As I am not getting the value there.
thanks
By:
Hemant Thaker
|
|
|
|
|
Hemant Thaker wrote: Is it possible ?
Yes.
What problem are you getting ?
Below is my web.config entry.
<appSettings>
<add key="k" value="123"/>
</appSettings>
Here is my Session_End Code.
void Session_End(object sender, EventArgs e)
{
string myval = ConfigurationManager.AppSettings["k"].ToString();
}
On Session_End, I am getting value myval=123.
|
|
|
|
|
Session end has nothing to deal with ConfigurationManager.
ConfigurationManageris a static class that Reads different section of ASP.NET config file and gives you the data.
I think it should be accessible from anywhere, even from Application_end. 
There might be some other issue with it, it is nothing to deal ConfigurationManager.
Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
Visit My Website-->www.abhisheksur.com
|
|
|
|
|
Hello I would like to show the edited text of the FCKEditor along with the pictures in a DIV tag, am I able to do that or no? if yes please help me to do so.
I have implemented the FCKEditor and it is working ok, I have uploaded the example (FCKEditor ready) code already, you can download it from here[^]
thank you in advance
|
|
|
|
|
u can also try Freetextbox it is very good as compared to the fck i m using this
<a href="http://freetextbox.com/default.aspx"></a>
thanks,
amit
|
|
|
|
|
Dear Amit, thank you for the reply but my problem is in showing the HTML code that is generated by these component in the page. I don't know how and where I can show them(in a DIV tag?).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
