How to insert data using Linq (I know Linq but in this form thing is different)

Question

0.00/5 (No votes)

See more:

I have created SignUp Form In Asp.net in this I am Using SQL Server Database. I Have Two Table Like EducationInfo and UserInfo . EducationInfo Table contain following column (EduId(PK),User_Id(FK),Degree,University,Passing Year,Percentage) and UserInfo Table contain following column (User_Id(PK),UserName,Password,FirstName,MiddleName,LastName,Country,City).

And finally i have create below form Like First Of User Fill Up Personal Information (FirstName,MiddleName,LastName,Coutry,City) than Education Information(Degree,University,Passing Year,Percentage) than Bind Grid Education Info than User Information (UserName,Password) .

In this form i have problem in insert data how in education info table and UserInfo table.

Without UserId how i am inserting in educationinfo table data....so help me sir/mem...

<body>
<form id="form1" runat="server">

------- Personal Info --------

<asp:Label ID="LblFname" runat="server" Text="FirstName">

<asp:TextBox ID="TxtFname" runat="server">

<asp:Label ID="LblMName" runat="server" Text="MiddleName">

<asp:TextBox ID="TxtMName" runat="server">

<asp:Label ID="LblLName" runat="server" Text="LastName">

<asp:TextBox ID="TxtLName" runat="server">

<asp:Label ID="LblCountry" runat="server" Text="Country">

<asp:TextBox ID="TxtCountry" runat="server">

<asp:Label ID="LblCity" runat="server" Text="City">

<asp:TextBox ID="TxtCity" runat="server">

------- Education Info --------

<asp:Label ID="LblDegree" runat="server" Text="Degree">

<asp:TextBox ID="TxtDegree" runat="server">

<asp:Label ID="LblUniversity" runat="server" Text="University">

<asp:TextBox ID="TxtUniversity" runat="server">

<asp:Label ID="LblPassingYear" runat="server" Text="Passing Year">

<asp:TextBox ID="TxtPassingYear" runat="server">

<asp:Label ID="LblPercentage" runat="server" Text="Percentage">

<asp:TextBox ID="TxtPercentage" runat="server">

<asp:Button ID="BtnAddDegree" runat="server" Text="Add Degree" Style="margin-left: 23%;" OnClick="BtnAddDegree_Click" />
<asp:Label ID="LblResultDegree" runat="server">

<asp:ListView ID="LstSignUp" runat="server">
<emptydatatemplate>

<asp:Label ID="LblEmptyData" runat="server">

<asp:Label ID="GrdHDegree" runat="server" Text="Degree" >

<asp:Label ID="GrdHUniversity" runat="server" Text="University" >

<asp:Label ID="GrdHPYear" runat="server" Text="Passing Year" >

<asp:Label ID="GrdHPercentage" runat="server" Text="Percentage">

Posted 30-Jun-14 21:07pm

keyur_raval

Add a Solution

Comments

keyur_raval 1-Jul-14 5:08am

Anyone please quickly reply me......

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

praveenlob7 · Answer 1 · 2014-07-02T00:09:00

First insert data in UserInfo table and get the identity column in the same query. Using the identity value insert the educationinf data.

Here's an example of how that works:

C#

var dc = new MyDataContext();
var cust = new Customer{FirstName="John", LastName="Smith"};
dc.Customer.InsertOnSubmit(cust);
dc.SubmitChanges();
//after SubmitChanges(), the Id is filled from the database
var customerPrimaryKey = cust.Id;