I have followed a tutorial and got a shopping cart working with some products in my database.
It uses the querystring to add the items to the cart on a different page. What i would like to do is submit the items in the cart to the database, if anyone would be able to guide me into doing that it would be great.
Here is my code:
View Cart Page which outputs using a repeater:
[Code]....
I'm trying to display the day most orders were placed, and how many orders were placed.
I use the following LINQ to get find what I'm looking for:
[Code]....
I want to display this as follow:
12 orders were placed 01.01.2010.
I get the ordercount using this:
[Code]....
But how can i get the day?
var topDay = from o in orders
I have a form that submits one entry to a 'Listings' table and multiple entries to a 'ListingLocation' table depending on how many cities the user selected. When the listing is created, I need the auto generated 'id' field to input into each of the the listing rows of the 'ListingLocation' table. This seems like it should be simple but I cannot figure it out. I currently have it hardcoded to enter '22' where I need it to enter the listing id.
<script runat="server">
I have an entity "Order", which contains a set of states. Every state has date and name.
I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.
Microsoft has two very helpful articles on DAL (Creating a Data Access Layer) &
BLL (Creating a Business Logic Layer) but they are Incomplete as the does not cover all the Tables.
The most Important tables in Northwind db are Orders & OrderDetails. Both the articles have nothing about them.
Can You send me the code of mention website [URL]. open the website and put the 10 no's. with press enter one by one show the result in table format or gridview like this.
View 1 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesi would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
View 1 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
When users submits data, I want to send an automatic e-mail acknowledging their submission. Below is the code I am running now, which basically submits data into the DB.
[Code]....
I need to submit all the CheckBoxList values on this page to a SQL database. It needs to submit if checked or if not checked. how I should code this in my code behind page?
[Code]....
I am trying to redirect the user to another page after they submit a form which posts to a sql 2005 database. I found the response.redirect but I can't get it to work.
Here is my code behind:
Partial
Class
Default2
Inherits System.Web.UI.Page
Protected
Sub FormView1_PageIndexChanging(ByVal
sender As
Object,
ByVal e
As System.Web.UI.WebControls.FormViewPageEventArgs)
Handles FormView1.PageIndexChangingEnd
Sub
Protected
Sub SqlDataSource1_Selecting(ByVal
sender As
Object,
ByVal e
As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
Handles SqlDataSource1.SelectingEnd
Sub
End
Protected
Sub Page_Load(ByVal
sender As
Object,
ByVal e
As System.EventArgs)
Handles
Me.LoadEnd
Sub
Class
used Ajax.BeginForm for form submitting.For the fields I want to show watermark if there is no data in database.But on submitting watermarks are saved in database.
View 6 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 Replieshow to send email when you submit a new request into the database.
View 6 Repliesi have this form, that the data is stored in a SQL db using Linq.
my question is, how can i add a column, that will have all the information about the sender, meaning IP address, browser, referrer etc.
the thing is is i want to store it in one field. i come from a php knowledge that has been long forgotten by me, but i still remember there was some serialize command, that you could run on an array and store it in a db, then when you want it back to an array you would just run deserialize command and it would go back to an array.
How to add code to redirect my user on successful submit to my database.
Code...
Imports System.Data
Imports System.Data.SqlClient
Partial Class CPD_OnlineSurvey
Inherits System.Web.UI.Page
Public Sub UpdateOnlineSurvey(ByVal sender As Object, ByVal e As EventArgs)
Using conn As New SqlConnection()
conn.ConnectionString = ConfigurationManager _
.ConnectionStrings("wincts").ConnectionString
Using cmd As New SqlCommand()
cmd.CommandText = "update OnlineSurvey set IsSelected = " & _
"@IsSelected where QuestionId=@QuestionId"
cmd.Connection = conn
conn.Open()
For Each item As ListItem In ChkOnlineSurvey.Items
cmd.Parameters.Clear()
cmd.Parameters.AddWithValue("@IsSelected", item.Selected)
cmd.Parameters.AddWithValue("@QuestionId", item.Value)
cmd.ExecuteNonQuery()
Next
conn.Close()
End Using
End Using
End Sub
End Class
I'm trying to insert few values to a table, when i press the submit button the aspx page goes blank and i don't get any error message. I'm not able to find where the error is.
The code:
Protected Sub AddMInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddMInfo.Click
really new to the programming scene. writing a program so when i select an item from a drop down list i click the submit button and i want it to display the items selected from the database in a gridview. so in short i want to select an item click submit and i want it to display the information from the database.
View 2 Replieshow to convert date in textbox which is in format(dd/mm/yy) to mmddyy before submit to database.
View 21 RepliesI have a form with multiple submit buttons:
using(Ajax.BeginForm("Submit", "myController", new AjaxOptions { HttpMethod = "Post" }))
{ %>
<button type="submit" name="submitType" value="submit_a">a</button>
<button type="submit" name="submitType" value="submit_b">b</button>
<% } %>
I need to send some parameters to an external website using the <asp:HiddenField /> controls and also at the same time, submit data to a sql server database. The part for submitting the data to the database is working, but I need to try to get the parameters from the hiddenfields to also be passed through. I thought all I had to do is create the hidden fields and in the code behind, set the values from the textboxes that the user would fill out.
My source code is below:
[code]...
What am I missing? The hidden fields are losing their value before posting to the external website. I've looked everywhere to see why this won't work.
In ASP.NET when we have multiple input section with required field validator (Like on header for login with userid & Password is required and second on footer for subscription) when we click on subscription login section's userid required field validator activates and say userid required & i can not submit subscription.
when i submit subscription details login section should not have concern with this. how to avoid this conflicts.