MVC :: Save Data To Two Associated Tables In A DB?
May 3, 2010
I have a little problem concerning the saving in two associated tables !
explanation :
i am using sql server 2008 and MVC 1.0
for the saving and edition i used the standard methode, wich is (using control and repository classes, and then "the add view" fonctionality).
in my case , i have a table A associated with another table B, this means that in the A i have other columns belonging to the table B, but when using the Add view, it doesn't add the ather column of the table B, even if in the sql server, in the design of the table i find these columns!
the code for grabbing data is:
[Code]....
and for the view here is the code generated:
[Code]....
the aim here is that i want to add for exampl an other property:
[Code]....
I have a form with several DropDownlists and TextBoxes, Each dropdownlist depends on the selection of the previouse one.. and there is a submit button. Once the user clicks on it, information entered by the user is displayed in a GridView and saved as well in the database. The GridView holdes information from two tables I used joining) , but once I click on the Submit button I receive this error: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. Source Error:
[Code]....
Imports System.Data.SqlClient Imports System.Web.Configuration Partial Class Members_MembersCalculator Inherits System.Web.UI.Page Protected Sub CalculateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CalculateButton.Click Dim objConnection As SqlConnection Dim objDataCommand As SqlCommand Dim c_manu, c_model, c_date As String Dim sSQL As String Dim ConnectionString As String Dim c_factor As Double Dim c_result As Double Dim c_milage As Double Dim c_id As Integer Dim c_year As Integer c_manu = ManDropDownList.Text c_year = YearDropDownList.Text c_model = ModelDropDownList.Text c_milage = MilageTextBox.Text c_factor = FactorDropDownList.Text c_id = CarIDDropDownList.Text c_date = CarDateTextBox.Text c_result = c_factor * c_milage ConnectionString = WebConfigurationManager.ConnectionStrings("Carbon_free_ConnectionString").ConnectionString objConnection = New SqlConnection(ConnectionString) objConnection.Open() sSQL = "Insert into car (Manufacture, year, Model, car_factor)" & _ "values('" & c_manu & " ', ' " & c_year & " ',' " & c_model & " ', ' " & c_factor & " ')" objDataCommand = New SqlCommand(sSQL, objConnection) objDataCommand.ExecuteNonQuery() objConnection.Close() objConnection = New SqlConnection(ConnectionString) objConnection.Open() sSQL = "Insert into car_Result (car_id, car_Result_Date, Car_result)" & _ "values('" & c_id & " ', ' " & c_date & " ',' " & c_result & " ')" objDataCommand = New SqlCommand(sSQL, objConnection) objDataCommand.ExecuteNonQuery() objConnection.Close() msgLabel.Text = "Your records have been calculated successfuly, Thank you." 'CarDateTextBox.Text = "" 'MilageTextBox.Text = "" CarGridSqlDataSource.DataBind() CarGridView.DataBind() End Sub End Class
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
i would like to find out how to go about displaying data from multiple database tables on the same page. What i mean is it would look like the feeds on the facebook home page where you can see the information like newply uploaded photo or a new post.
I have two tables, and i want to display any newly created row on my home page from either table in the same control. Currently, i have two gridviews, but i want the data from both tables be displayed together.
i have a details table which include detailid, custname, address, classification , pincode, telephone, remarks and classification table contain classification id & classification.i want to insert detailid & corresponding classificationid to a new table detail_classification. How to write stored procedure for that?
How do I display table database information from two or multiple databases tables where they are linked by one field? For instance, I have an Orders Table and Customer Table, and both are linked by OrderID, and I'd like to display all Orders and the corresponding Customer information.
I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].
There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?
Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.
here I can find some info on how to display data from my MSSQL database in something like old style tables (table,<tr>,<td>) becouse I used to done it like this in classic asp but i had a formula for calculating where to put tr or td and it becomed very confused, not to mention displaying gruped records like 10 on each page...I tried gridview in VisualStudio but I can not find any info how to use sql in it so I think it can not help me becouse it is to much predefined and I do not know where I can change code for it like what data source to use, sql and other important thing
I have two tables. 1st contain topic and its id. 2nd contain topic name,its category and category list.
I want to display using asp .net datalist and vb script like the following
topic 1 Category 1 categorylist 1 of category 1 categorylist 2 of category 1 Category 2 categorylist 1 of category 2 categorylist 2 of category 2 topic 2 Category 1 categorylist 1 of category 1 categorylist 2 of category 1 Category 2 categorylist 1 of category 2 categorylist 2 of category 2
Also, i have tried displaying only Category 1, 2 .. which are Link button. When I click these button it shows category list. So here I am facing aproblem that everytime i click these buttons it refreshes my page which is very annoying.
I need to insert data into two relation tables, the parent table have an ind colum, which is an auto inser number , how can I get this auto number and insert it into the child table , in asp I see somthing like MyId = ExecuteIdentity(Mysql ), How Is in asp net 1.1 with Vb
I want to display data from one record in a ListView control. There are two other tables that could contain associated records. For each table, if there is an associated record, I want to display the data from a particular field. I'm only concerned with the item amd alternate templates
I'm using VWD 2008 and using an SQL database with a simple web app.
I've created a SQL query that pulls data from several tables. When I execute the query in
the query builder tester, it executes OK. I'm binding the DetailsView to an ObjectSource / DataSet / TableAdapter Querry with a variable that is bound to a listbox control.
Again, the query runs fine in the query builder.
When the detailsview or gridview gets built on the page it only displays columns from one database yet it executes ok within the query builder.
I can see the generated code for the detailsview does not create fields for every field returned by the sql query ?
i have a problem in joining two tables the reason ismy first table persdata is having common field as pno (a single row in a particular person) and the second tables is also having pno(having muti entry for a person as this table is of qualification and a person may have more than 3 qualifications and their grading)sample persdata(table)pno name coy appt sample qual(table)pno qual grading recommendationi tried my best to do it and not able to proceedi want the output in a single row as in persdata to a gridview with all the qual combined in one coloumn and all the recommendations combined in one coloumn for a person.
I have to display records from two tables where foreign key table contains many values for a primary key column how to get the data using linq query???
