I am building an appplication in Flex which shows and lets edit values from a SQL Server DB. To start out, I made a Web Service which verifies the username and password. I hava a simpe table with two columns: username and password I managed to send values to the web service but I am stuck with the logic to verify that the username is the same as in the DB.
[Code]....
i want to retrieve latest 10 values from my table,i use sql server 2000.. how can i query my database?
View 4 RepliesI want to assign values that retrived from database to labels.im using select command.but it doesnt work.
[Code]....
my table customer table contains attributes Name,age,email and address.i want to ask user to enter to his id to display his datas.
after he enterd his id each label will be assigned with the database values accordingly.i tried like above.couldnt get the output.
I populate web form with dynamic list of exams from database. I want user to enter examination marks for each exam. There is list of exam titles and textbox near each title.I create list with repeater control (ViewState is disabled)
class Exam
{
public int Id { get; set;}
public string Title { get; set;}
}
...
// this list is retrieved from database actually
Exam[] Exams = new Exam[]
{
new Exam { Id = 1, Title = "Math"},
new Exam { Id = 2, Title = "History"}
[code]...
My problem is regarding title written above. Currently I have some functions that rely on Sessions to do the job. Everything works smoothly when it is left to default. However, I do not like the idea of losing sessions in case of crash and I have modified my web.config to use Sql Server mode instead.
I have run the necessary commands to create tables and stored procedures in my database using aspnet_sql.exe. I am able to store values into the database but have not been successful retrieving them. Since it has been working fine with InProc mode, I think I can safely assume that there's nothing wrong with my codes. Here's my web.config setting:
<sessionState mode="SQLServer" allowCustomSqlDatabase="true" cookieless="false" timeout="120" sqlCommandTimeout="30" compressionEnabled="true"
sqlConnectionString="Data Source=.SQLExpress;Initial Catalog=mytest;Persist Security Info=True;User ID=mytest;Password=mytest;"/>
I want to log the assembly version information into a log file each time my WCF web service is called. I know that in an application the My object has an Application object which has the Info structure, that contains the Version string that I can use. How can I get the version information for the WCF service to a log?
View 1 RepliesI need to write a web service which will generate excel file by using the records present in the database or depending upon the query fired.
So how should I try this?
i was wondoring which thing is better from below two... first one- retrive data by creating webservice second one- create database connection from code behind call storeprocedure and retive data
View 6 RepliesI have to retrieve the data from the web service and this data should be kept in process's memory and use it where needed.Do not like to call web service every time.Is there any method to do this?
View 2 Repliesi am running with an unfamilier issue with jquery ajax and wcf service . i have created a simple wcf service and trying to show it on a asp.net label... the wcf service just returns a string which has to b shown on a label. the url has been set on jquery ajax url to call the wcf service using rest. but somehow i am not getting the desired thing done . the ajax cannot retrieve the data from the wcf service , here are the code snippets.
The Ajax Portion in default.aspx :
[Code]....
The Service Contract for WCF :
[Code]....
The implemented Method :
[Code]....
and the Web.Config :
[Code]....
can someone figure out here i am going wrong .... that the ajax is unable to retrieve the data from the above wcf Service .. its just a very basic and simple one .. but unable to figure out the Real Prblem.
I have a simple web app built in asp.net webforms c#where and how would be the best way to save info from the code behind?(and also retrieve that info)eg all i want to save is a dateTime. and a flag set to True or False.and be able to access them in the code behind.Im not using a db for this web app.Edit: and can't really use session variables for this purpose.
View 5 Replieshow to retrieve a value from a typed dataset. I am trying to retrieve a value from a row within a row return from a tabale adapter method. Example:
Dim transAPI As New PN_TransactionBLL()
Dim trans As PN.RetrieveGEmailDataTable = transAPI.getGEmail(itemtId)
The tabeadapter method retrieves 1 row of data and I would like to pull the values retrived such as "trans.rowproperty"(if thats the correct syntax) where "rowproperty" would contain the actual value returned.
I am creating an ASP.NET application that allows the user to add form elements to a page within a form. When the page is posted (via the submit button) I need to loop through ALL the posted values in the form and get the values.
I can't check for specific values as I don't know how many there will be or what they will be called.
Could someone point me in the right direction of getting ALL posted values so I can loop through them?
p.s I was looking in Request.Form but couldn't see anything obvious to use.
I am having a form in a view page that looks as below:
[Code]...
Now when the form is posted, I am trying to retrieve the values submitted in the controller as below:
[Code]...
The string value shows null when I submit the form by checking some checkboxes. Is this the way to retrieve the values or am I doing something wrong? And I cannot use html control because all other controls on the form are server controls and I am not sure if I can only make this control a html control. And I am not sure how can I bind the values to it?
I have a checkboxlist on a form and need to find out howI go about finding the values of the ones that might be checked .
<asp:CheckBoxList ID="cbSpillCleanUp" runat="server">
<asp:ListItem Value="EmergencyResponse">911/Police/Fire</asp:ListItem>
<asp:ListItem Value="CentralStation">Central Station</asp:ListItem>
<asp:ListItem Value="ERV">Environmental Response Vendor</asp:ListItem>
<asp:ListItem Value="RegAgency">Regulatory Agency</asp:ListItem>
</asp:CheckBoxList><br />
I have two tables related to a number (ie, persons with Firefox), I should retrieve data from a View where he imposed the following code:
[Code]....
When I go to send the following to view controller via Post did not recover the data, the controller parameter dell'actin as I pass him the Person object p.Qualcuno potrebe me explain why I get the results and those of the Person objectcomponents, I do not return?
this method is meant to retrieve two database field values, but i'm getting error: Must declare the scalar variable "@FlyingFrom".
[Code]....
i have a question how to retrieve the row values as a column. please check the below tables i need the query for this table.
[Code]....
A strange issue.. and probably some key thing I am missing...I am using the MS Enterprise Library version 5.0.. specifically the cache engine.
I have a website where from a certain page I do the following:
Cache some values I need for the next page or two..
Go off to another site - actually a payment site..
That payment site returns to my site..
I retrieve the cache values to show..
Ok, I know I am going to probably get shot here.. but apparently on the "odd" occasion, a user says they see the details from a previous user?
I thought when you cache an item (session, cache or whatever), this is only relative to the users session?
how can i dissect or retrieve string values
Here's the sample code that im working on now
private void SplitStrings()
{
List<string> listvalues = new List<string>();
listvalues = (List<string>)Session["mylist"];[code]....
now that i'am able to retrieve List values in my session, how can i separately get the values of each list using foreach or for statement? what i want to happen is to programmatically split the values of the strings depending on how many is in the list.
I have the following code which creates a treeview of a folder and files on my PC. The front-end code is the following:
[Code]....
I have following in the code-behind file:
[Code]....
The result is a web page that allows me to navigate down to individual music files within various folders. Beside each music file is a checkbox.What I want to do is select several files and then click a button that will move the selected files from their existing location to another location. I'm running into two problems. One, whenever I add any control that performs a postback, the treeview doesn't repopulate. Two, I don't know how to retreive the values of the checked checkboxes.
It's there a way to retreive cookie value in ASHX Handler ?
I set a cookie in a page, and i want to reteive it in my ashx. My cookie is always null.
I save my cookie like this
HttpCookie tokenCookie = new HttpCookie(cookieName);
tokenCookie.Values["siteGuid"] = authenticationInfo.SiteGuid.ToString();
HttpContext.Current.Response.Cookies.Add(tokenCookie);
I retreive my cookie like this
HttpCookie cookie = HttpContext.Current.Request.Cookies[cookieName];
return new Guid(cookie["siteGuid"]);
Ok sorry that was my fault. My handler was on a sub domaine.
The method has a return type of collection, i am calling the method from the aspx page in order to populate a drop down -> ddlDropDown. I am binding he DataTextField of the ddlDropDown with the BusinessEntity.Name and the DataValueField with BusinessEntity.Id, the business entity contains another id which is BusinessEntity.ProductId. I need to use the ProductId of the value selected in the drop down list in the code behind.
One possible way could be to call the method in the page_Load on the code behind and save the collection in a hidden variable and when required do a loop through in the hidden variable and retrieve the selected value Product Id.
I have created two objects and placed id ViewData , I dont Know how to retrieve values of each object in the view..
var t = new List<Table1>()
{
new Table1 {Id = 123400,Name="Kalees00"},
new Table1 {Id = 12340011,Name="Kalees0011"}
};
ViewData["ListValues"] = t;
return View(t);
I am trying to get attachment from the SAP XI Web Service which is returning the following soap response..
--SAP_db9e7598-e284-11df-9fcf-001125a6de68_END