I have a cart application I am working on where I need to assign a value based on a query string. I am telling the code behind to override the price returned by a linq query with the price in the value of the price variable passed by the string. The default linq value for this item is zero, and isn't updated by my attempt to override. Here is what I am trying with no success so far. Query format sent to page is .....aspx?Price=
How it is possible to assign datatype of an attribute retrieved using sql query to a string? for eg:
SqlCommand cmd = new SqlCommand("select data_type from information_schema.columns where table_schema='dbo' AND table_name=table1 AND column_name=column1, con);
I want to assign this datatype value to a string. How it is possible?
i have to assign value to bit varibale.so i declared bool variable . i am assigning string value to a bool variable . so i converted to boolean & assigned.Its not converting to bool..How to assign string value to bit variable.?i am getting error.Object reference not set to an instance of an object
in my asp.net+vb+access web i am having a page in which i am counting and displying the numbers in text boxes/labels. it works fine.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:webWing.mdb" Dim con As OleDbConnection = New OleDbConnection(connectString)
[Code].....
i want to amend the value with the value of the text boxes that i had tried manually it works fine.
I need to assign string to repeater label on button click but it is showing error object reference not set
//Label date = (Label)Repeater.FindControl("ltpl_datefor"); Label date = Repeater.Items[0].FindControl("ltpl_datefor") as Label; date.Text = dateforloop.ToString().Substring(0);
I need to create a form showing our production numbers for the week on each line. I can do this in listview using grouping and totals. The problem is I want these numbers to show in a form so I can cutomize the look of the report. Is there any way to assign a query to each text box on a form?
New to Linq and Var type have a method where linq query is executed, want to return the result and assign it to GridView. but method don't take the return type as var.
So was wondering how do i return this query result?
Should i assign this result to DataTable first and make the method return type as DataTable?
Here is the code, This is what i want to do but not sure what is the right way
I have an entry page that contains a datalist. I also have an ascx user control page that when it runs on page load, renders an html table template which contains category information from an SQL self referencing table. When the SQL query run on page load, it bind the results to a datalist called dlCategory, and repeats for all rows that have no value in a field in this SQL table called ParentCategoryCode. The SQL table is called ServiceRequestCategories and basically consists of CategoryCode, CategoryTitle, and CategoryDescription, and may or may not have a ParentCategoryCode associated with it.
Records without a ParentCategoryCode are top level categories, and anything that has a ParentCategoryCode are second or third level categories. The way I have the data set up, it ends up being 4 rows that are returned and rendered as 4 html tables. Each one of these is tied to the user control, and each user control runs another datalist, and shows all CategoryTitle values for each Category that has a ParentCategoryCode (second level categories). This works when you click on a LinkButton for any CategoryTitle. This all works fine.
My question is, how can I use an SQL select query to plug the value of the CategoryTitle into a label called lblCategoryBreadCrumb on my main entry page? Here is my code, but it does not seem to work.
Protected Sub ShowBreadcrumbLabel() Dim strSQL As String Dim dsData As DataSet Dim dtData As DataTable
I used a query which returns some rows as result.. Querys is
var UserActivity = (from x in entity.user_activities oin p in entity.team_group_friends on x.activity_doer equals p.userid where p.userid == teamORGroupID select x).ToList().Take(5);
There is no error in query...But when i assisg the UserActivity to a view model ..
I have an sql database, with a users table that has username and a colour.
My asp master page is reading the current users username and passing it to the content fine.
What I am trying to now do is in the content page grab the colour from the sql table where the username is the current username, and assign it to a string inside the default.aspx.cs file.
We are sending an HTML encoded string in the Query string. It was working fine on IIS 6 (windows 2003). We have recently moved the website to Windows 2008 (IIS 7.x). Since the move any Query String that contains "+" sign i.e., "%2b" gives error on the server "404 -File or directory not found."
I wanted to create a URL like http://localhost/menu.aspx/?id so that on typing this, it displays all the id's in the database. for eg:134
123
543
234
may be the id's which should be displayed after fetching from the database. However, it should be displayed as it it is without any control or without arranging in any gird etc. How can that be done?
I'm using webservice to integrate asp.net app with PeopleSoft. Sometimes, the value that I get from a querystring (eg in url below, request id =7) and pass it to PeopleSoft via webservice is blank, although the querystring contains key value pair. This causes the webservice integration piece to fail. What can cause this issue where the querystring value is blank? and how can I fix it?
I am using query string when I do a Page redirect.Please could somebody give me an alternate solution for this.I do not want to use Query string in this case
In index.aspx I have 1TextBox and 1Button when user enter their behcode in TB and click on Button it go to store.aspx page and fill this page with that user information
Now I want when user enter their behcode in index.aspx and according to that behcode go to store.aspx and see their page when they click one of 2 button in store.aspx they go to article or about us page and in that page again fill with them information from user’s table according to behcode that they entered in index.aspx page.
i have a page from which i send a email to a client which has link to this page with a query string. when we click we fetch the value of query string in the page load. But its showing an error when we load the page because at that time we are not sendign the query string.
I am passing values through query string. I want to restrict the user to modify the url to get the unauthorized permissions.I want to encrypt the url so that user can not understand and decrypt and use in the code.How can i do this.If there is any method to restrict the user to modify the url,
