|
|
Hi,
In my ASP.NET website, I used a stored procedure to retrieve some records which has more than one records. In stored procedure I do
SELECT @taskid=taskid, @taskdescp=taskdescp
FROM tb_ticket_task
WHERE tickid=@tickid
But this would return only one record, does stored procedure return any record set which I have been trying to find from the internet but couldn't.
If stored procedure cannot return record set, any alternative I can use using C# in ASP.Net?
Thanks
J Liang
|
|
|
|
|
J Liang wrote: But this would return only one record
Check whether for the particular @tickid are there multiple rows in the tb_ticket_task table.
Hope, as the result is stored in variables it is returning only the last value.
try using select query with only columns i.e.
SELECT taskid, taskdescp FROM tb_ticket_task WHERE tickid=@tickid
J Liang wrote: If stored procedure cannot return record set, any alternative I can use using C# in ASP.Net?
Create a function in SQL Server with return type as table.
Regards
KP
|
|
|
|
|
Hi,
Please let u know how do u execute the SP in your code?
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
Hi KP,
it works and I should have knew it, hehe.
I used myCommand.ExecuteNonQuery() instead of myCommand.ExecuteReader() which explain why I could not get all the records.
Then I do while (reader.read()) and assign all I got into an ListItem then to a PlaceHolder. All the data successfully retrieved.
Thanks.
J Liang
|
|
|
|
|
Hello,
So I am working on a project to transfer database data from different locations into one central database via webservices. My initial thought was to install the webservice on the database servers in the different locations and have the consumer webservice installed on the central database server invoke the webservices at each of these locations to update the central database. Now I don't know if that is the right way to do it as I have no clue as to how to differentiate between the webservices in these different locations and how to even call them. Please help. Suggestions and coments as to how I can go about this will be appreciated. Than you.
Nana
|
|
|
|
|
greetings...
another wonderful day and new challenges...
sir/mam, i again need your help on how to manage session in asp.net 2003...
--- is there a way, how to set a session timeout?
--- can someone give me a link for other sample in session management?.. thank you in advance........
start a new beginning in every ending; thats what life for......
|
|
|
|
|
Hope the Article by Narendra Naidu Here[^]
And also the Article by Mandeep S Bhatia here[^] in CP will Help you regarding the Session Management.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I have an interesting situation. I am doing a DB query to lookup email addresses from a SQL server table. I want to then put those addresses into an email to be sent programmatically. So there could be anywhere from 1 to x email addresses. Kind of new to asp.net and was curious as to the communities thoughts on if an array or collection would be better, or something else?
Ben Jones
|
|
|
|
|
I would say use System.Collections.Specialized.StringCollection
This is a specialized collection of strings..
Or you can use System.Collections.Generic.List<string>
i.e.
System.Collections.Generic.List<string> myList = new System.Collections.Generic.List<string>();
If you know the exact number of results, array is just raw memory and fastest too, whereas using these above data structures requires some overhead..
|
|
|
|
|
Great thanks for the advice!
Ben
|
|
|
|
|
Hi,
we are using asp.net 2.0 calendar control on our website. I have painted the calendar days with event information and set the tooltips for those days using javascript. But when the user hovers the mouse on the calendar, first it is displaying the control tooltip "Calendar" and if we wait for some time the tooltip will go away and the assigned tooltip will appear. How can I disable the control tooltip?
Thanks,
sridhar.
-- modified at 12:26 Wednesday 13th June, 2007
|
|
|
|
|
Can any one help me in develing a row-clickable DataGrid control?
thanks
kidus
|
|
|
|
|
Hi,
You want to execute any server code on click of the row in datagrid?
If you want to use javascript then you can write follwing code in ItemDataBound event of Datagrid.
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItem.AlternatingItem)
{
e.Item.Attributes.Add("onclick", "urjavascriptfunction");
}
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|
|
if (dgvEmployee.CurrentRow.Index == -1) // Is there any row selected now?
return;
// Retrieve the first column from the selected row.
int Id = Convert.ToInt32(dgvEmployee.CurrentRow.Cells[0].Value.ToString());
This gives the particular value in the row of cell 0 ...If it help carry on
came out of hardwork
|
|
|
|
|
I have an XML file in my app_data directory. My Data Access layer (a class library project) needs to know where the XML file is.
I currently have:
c:\projects\My website\ (solution file is here)
c:\projects\My website\website (aspx files, web config, & junk)
c:\projects\My website\website\app_data\ (a few database files and an xml file)
c:\projects\My website\websiteDA\ (project folder for data access class library)
If I add the DA class library project as a reference to my website project, is there any way for the class library to know what the data directory of the website may be.
Using something like:
XmlTextReader settingsReader = new XmlTextReader("settings.xml");
tells me it's looking in:
C:\projects\My website\
the same folder as the solution file. Very odd. I would have expected c:\projects\My website\website
DB access gets around this by somehow parsing "|DataDirectory|" in the connection string, resolving it to match the app_data path. Could I do something similar?
-Mike.
|
|
|
|
|
|
That works if I'm trying to resolve a path from a page in the web project. However, I'm trying to accomplish the same from inside a class library referenced by the web project.
-Mike.
|
|
|
|
|
The class library code is running in appdomain of the web application so you have access to the HttpContext.Current.Server.
only two letters away from being an asset
|
|
|
|
|
I managed to solve my own problem, and here it is:
string strDataDirectory = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
http://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx
-Mike.
|
|
|
|
|
Have a menu control working fine, but need a couple tweaks. Example (assumes background white, hover background gray, also using css)
<asp:MenuItem Text="Cat" NavigateUrl="#" />
<asp:MenuItem Text="Persian" NavigateUrl="#" />
<asp:MenuItem Text="Calico" NavigateUrl="#" />
</asp:MenuItem>
<asp:MenuItem Text="Dog" NavigateUrl="#" />
<asp:MenuItem Text="Golden" NavigateUrl="#" />
<asp:MenuItem Text="Collie" NavigateUrl="#" />
</asp:MenuItem> Anybody know how or a tutorial that will show me how to do two things:
1. When hovering over "Collie", have the background of Dog be the hover color.
2. When hovering on "Collie" item but not on "Collie", have the entire item background be gray. Right now, if the text is short, and you hover to the right of the text within the item, the background remains white behind the text. I would like for the background to turn gray on the parent item, and the entire single item now matter where the mouse appears.
Thanks so much,
Janet
|
|
|
|
|
You'll need to use another control or write some custom javascript to handle these actions.
The menu control is rendered as a html table with the items as anchor tags in the cells. You would need to write some javascript to handle the onmouseover event of each anchor tag and adjust the colors as appropriate.
only two letters away from being an asset
|
|
|
|
|
When you say "use another control" - can you suggest one that would do as I would like? Or, would they all have the same rendering problem?
And/or, do you know of a control or someone who has written the onmouseover for the menu control as you have described? Perhaps one you could recommend for a fee?
The main thing I'm looking for is the parent to retain the 'hover' color when on it's child.
jb
|
|
|
|
|
Another third party control may provide better a experience for you. Without knowing your complete requirements or architecture I can't really recommend one.
If you want ot contact me offline we can discuss it further.
only two letters away from being an asset
|
|
|
|
|
I have a sumit button in aspx page.
function showProcessform()
{
Response.Redirect("processform.aspx");
return true;
}
when I click on button it doesn'r redirect me to processform.aspx page. It gives me error
seema
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
