我正在尝试使用linq将所有值从一个表插入另一个表。 [英] I'm trying to insert all values from one table to another using linq.
本文介绍了我正在尝试使用linq将所有值从一个表插入另一个表。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当在另一个表(User_Information)中插入值时,它表示不能在表(ID)(主键)中插入空值。但我正在将价值传递给主键!!
我尝试过的事情:
我的GridView是: -
When inserting the values in another table (User_Information) it says cannot insert null values in the table for column (ID) which is primary key. But I'm passing value to the primary key!!
What I have tried:
My GridView is:-
<asp:GridView ID="GrdVwViewUser" runat="server" EnableViewState="true" BorderStyle="None" AutoGenerateColumns="false"
CssClass="col-md-4 col-xs-4 text-center">
<columns>
<asp:TemplateField HeaderStyle-CssClass="heading text-center text-info" HeaderText="Users Details" HeaderStyle-Font-Size="30px" HeaderStyle-Height="40px" ItemStyle-CssClass="form-group">
<itemtemplate>
ID : <asp:Label ID="LblID" runat="server" Text='<%#Eval("ID") %>'><br />
UserName : <asp:Label ID="LblUserName" CssClass="form-inline" runat="server" Text='<%#Eval("UserName") %>'><br />
Password : <asp:Label ID="LblPassword" runat="server" Text='<%#Eval("Password") %>'><br />
FirstName : <asp:Label ID="LblFirstName" runat="server" Text='<%#Eval("FirstName") %>'><br />
LastName : <asp:Label ID="LblLastName" runat="server" Text='<%#Eval("LastName") %>'><br />
Email : <asp:Label ID="LblEmail" runat="server" Text='<%#Eval("Email") %>'><br />
PhoneNo : <asp:Label ID="LblPhoneNo" runat="server" Text='<%#Eval("PhoneNo") %>'><br />
Location : <asp:Label ID="LblLocation" runat="server" Text='<%#Eval("Location") %>'><br />
Created_By : <asp:Label ID="LblCreated_By" runat="server" Text='<%#Eval("Created_By") %>'><br />
Gender : <asp:Label ID="LblGender" runat="server" Text='<%#Eval("Gender") %>'><br />
Date of Birth : <asp:Label ID="Lbldob" runat="server" Text='<%# Convert.ToDateTime (Eval("dob")).ToString("dd-MMM-yyyy") %>'><br />
Region : <asp:Label ID="Lblregion" runat="server" Text='<%#Eval("region") %>'><br />
Language : <asp:Label ID="Lbllang" runat="server" Text='<%#Eval("lang") %>'><br />
Deleted : <asp:Label ID="LblDeleteUser" runat="server" Text='<%#Eval("DeleteUser") %>'><br />
Registered On : <asp:Label ID="LblRegisterDate" runat="server" Text='<%# Convert.ToDateTime (Eval("RegisterDate")).ToString("dd-MMM-yyyy hh:mm tt") %>'><br />
About Me : <asp:Label ID="LblAbout" runat="server" Text='<%#Eval("about") %>'><br />
Authorised : <asp:Label ID="LblAuthorised" runat="server" Text='<%#Eval("Authorised") %>'><br />
<asp:LinkButton ID="LnkBtnApprove" runat="server" CssClass="btn-sm btn-info form-inline" CommandArgument='<%#Eval("ID") %>' OnCommand="LnkBtnApprove_Command" >Approve
</itemtemplate>
</columns>
和命令参数是: -
And Command Argument is:-
protected void LnkBtnApprove_Command(object sender, CommandEventArgs e)
{
long id = Convert.ToInt64(e.CommandArgument);
using (SampleDataContext dbContext = new SampleDataContext())
{
try
{
string uploadsucc = "";
//Insert Into User_Information from UserInfoPrimary
var insertuserinfo = (from r in dbContext.UserInfoPrimaries
where r.ID == Convert.ToInt64(id)
select r).FirstOrDefault();
if (insertuserinfo != null)
{
User_Information ui = new User_Information
{
UserName = insertuserinfo.UserName,
Password = insertuserinfo.Password,
FirstName = insertuserinfo.FirstName,
LastName = insertuserinfo.LastName,
Email = insertuserinfo.Email,
PhoneNo = insertuserinfo.PhoneNo,
Location = insertuserinfo.Location,
Created_By = insertuserinfo.Created_By,
Gender = insertuserinfo.Gender,
dob = Convert.ToDateTime(insertuserinfo.dob),
region = insertuserinfo.region,
lang = insertuserinfo.lang,
DeleteUser = Convert.ToChar(insertuserinfo.DeleteUser),
RegisterDate = Convert.ToDateTime(insertuserinfo.RegisterDate),
ID = Convert.ToInt64(id),
};
dbContext.User_Informations.InsertOnSubmit(ui);
dbContext.SubmitChanges();
}
//Insert Into register from registerup
var insertregister = (from r in dbContext.registerups
where r.ID == Convert.ToInt64(LblIDS.Text)
select r).FirstOrDefault();
if (insertregister != null)
{
register re = new register
{
education = insertregister.education,
employment = insertregister.employment,
profession = insertregister.profession,
employed = insertregister.employed,
income = insertregister.income,
emptype = insertregister.emptype,
district = insertregister.district,
region = insertregister.region,
community = insertregister.community,
subcaste = insertregister.subcaste,
gotra = insertregister.gotra,
mtongue = insertregister.mtongue,
language = insertregister.language,
pervalues = insertregister.pervalues,
state = insertregister.state,
country = insertregister.country,
height = insertregister.height,
bodytype = insertregister.bodytype,
complexion = insertregister.complexion,
cases = insertregister.cases,
diet = insertregister.diet,
drink = insertregister.drink,
smoke = insertregister.smoke,
hobby = insertregister.hobby,
about = insertregister.about,
UserName = insertregister.UserName,
ID = Convert.ToInt64(id)
};
dbContext.registers.InsertOnSubmit(re);
dbContext.SubmitChanges();
}
else
{
uploadsucc = "register error";
}
//Insert Into registerdetail from registerdetailup
var insertregisterdet = (from r in dbContext.registerdetailups
where r.ID == Convert.ToInt64(LblIDS.Text)
select r).FirstOrDefault();
if (insertregisterdet != null)
{
registerdetail regdet = new registerdetail
{
place = insertregisterdet.place,
raashi = insertregisterdet.raashi,
manglik = insertregisterdet.manglik,
father = insertregisterdet.father,
mother = insertregisterdet.mother,
brother = insertregisterdet.brother,
sister = insertregisterdet.sister,
familytype = insertregisterdet.familytype,
familyvalue = insertregisterdet.familyvalue,
UserName = insertregisterdet.UserName,
ID = Convert.ToInt64(id)
};
dbContext.registerdetails.InsertOnSubmit(regdet);
dbContext.SubmitChanges();
}
else
{
uploadsucc = "register detail error";
}
//Insert Into partner from partnerup
var insertpartnerdet = (from p in dbContext.partnerups
where p.ID == Convert.ToInt64(LblIDS.Text)
select p).FirstOrDefault();
if (insertpartnerdet != null)
{
partner prtnr = new partner
{
ID = Convert.ToInt64(id),
UserName = insertpartnerdet.UserName,
ppMaritalStatus = insertpartnerdet.ppMaritalStatus,
ppAge = insertpartnerdet.ppAge,
ppHeight = insertpartnerdet.ppHeight,
ppCommunity = insertpartnerdet.ppCommunity,
ppRegion = insertpartnerdet.ppRegion,
ppHomeDistrict = insertpartnerdet.ppHomeDistrict,
ppManglikStatus = insertpartnerdet.ppManglikStatus,
ppEducation = insertpartnerdet.ppEducation,
ppEmploymentStatus = insertpartnerdet.ppEmploymentStatus,
ppProfession = insertpartnerdet.ppProfession,
ppAnnualIncome = insertpartnerdet.ppAnnualIncome,
ppFamilyType = insertpartnerdet.ppFamilyType,
ppCurrentCity = insertpartnerdet.ppCurrentCity,
ppBodyType = insertpartnerdet.ppBodyType,
ppComplexion = insertpartnerdet.ppComplexion,
ppDiet = insertpartnerdet.ppDiet,
ppDrink = insertpartnerdet.ppDrink,
ppSmoke = insertpartnerdet.ppSmoke,
ppMore = insertpartnerdet.ppMore
};
dbContext.partners.InsertOnSubmit(prtnr);
dbContext.SubmitChanges();
}
else
{
uploadsucc = "partner error";
}
if (uploadsucc == "")
{
LblSubmitResult.Text = "Approved All Successfully!!";
}
else if (uploadsucc == "register error")
{
LblSubmitResult.Text = "Can't Upload in Register Table. No Data Given By User to Save!!";
}
else if (uploadsucc == "register detail error")
{
LblSubmitResult.Text = "Can't Upload in Register Detail Table. No Data Given By User to Save!!";
}
else if (uploadsucc == "partner error")
{
LblSubmitResult.Text = "Can't Upload in Partner Table. No Data Given By User to Save!!";
}
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "ErrorMessage", "<script>alert('Cannot Insert to Main Table. Contact Support')</script>");
}
UserInfoPrimary uip = dbContext.UserInfoPrimaries.SingleOrDefault(x => x.ID == Convert.ToInt64(id));
uip.Authorised = 'Y';
dbContext.SubmitChanges();
}
}
Please HELP!! I can’t find anyway to do this.
Please HELP!! I can't find anyway to do this.
推荐答案
Looks like it is issue with Link button and its command argument. Follow below code snippet:
Gridview code:
Looks like it is issue with Link button and its command argument. Follow below code snippet:
Gridview code:
<asp:gridview id="GrdVwViewUser" runat="server" enableviewstate="true" borderstyle="None" autogeneratecolumns="false" cssclass="col-md-4 col-xs-4 text-center" xmlns:asp="#unknown">
<columns>
<asp:templatefield>
<itemtemplate>
<asp:linkbutton id="btnApprove" runat="server">
CommandArgument='<%#Eval("ID")%>'
OnCommand="LnkBtnApprove_Command" Text="Approve">
</asp:linkbutton>
</itemtemplate>
.........
</asp:templatefield>
</columns>
.........
</asp:gridview>
Code-Behind code:
Code-Behind code:
protected void LnkBtnApprove_Command(Object sender, CommandEventArgs e)
{
int id = int32.Parse(e.CommandArgument.ToString());
// Imeplement your logic
}
这篇关于我正在尝试使用linq将所有值从一个表插入另一个表。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文