|
|
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?).
|
|
|
|
|
Hi.
I am fairly new to asp.net, and have a problem with a page I am working on. The page contains some textboxes, and a button. When the button is clicked, the codebehind fetches the textbox contents. If the user did something wrong, he is redirected to the same page again, but before that the textbox contents is saved in the session. When the page loads again the textboxes are now filled with this sessiondata so the user doesent have to input all the data from scratch again. But when the button is clicked the second time, the textbox content I read is the old content, and not the new data the user has typed in. How come?
To make my problem a bit easier to understand:
1. Page loads
2. User types "John" in the name textbox, and fills out other textboxes
3. User clicks the submit button
4. Codebehind reads "john" from the name textbox
5. Codebehind registers an error from the other stuff the user has filled in, and redirects to the same page with all textbox contents saved in session
6. Page loads, and all textboxes are filled from the session data
7. User changes the text in the name textbox to "Joe"
8. User clicks submit
9. Codebehind reads "john" from the name textbox - How come?!
Really hope you can help me understand this!
Thanks alot
|
|
|
|
|
It should not happen.Might be the case when user changes the data in the textbox and click submit then on pageload you are again filling the data from session.Debug the code and check the values in immediate window you might the get the issue.
One more thing, why you are taking the help of session, you can use viewstate.Enable the viewstate of the contrls on the page that will suffice your requirement.
|
|
|
|