我如何...从对象类型system.windows.forms.textbox到已知的托管提供程序本机类型不存在映射。 [英] How do i...no mapping exists from object type system.windows.forms.textbox to a known managed provider native type.

查看：98
本文介绍了我如何...从对象类型system.windows.forms.textbox到已知的托管提供程序本机类型不存在映射。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

命名空间TDApplication

{

public partial class Contactform：Form

{

SqlConnection con = new SqlConnection （Data Source = .\\SQLEXPRESS; Initial Catalog = TDApplication; Integrated Security = true;）;

SqlCommand cmd;



//更新和删除记录中使用的ID变量

int ID = 0;

// int ID = @tdtext;

/ / int ID = tdtext.Text;



public Contactform（）

{

InitializeComponent（）;

DisplayData （）;

ClearData（）;

}



//插入数据

private void btn_Insert_Click（object sender，EventArgs e）

{

if（TitalcomboBox.Text！=&& NametxtBox.Text！=）

{

cmd =新的SqlCommand（插入TDContact（标题，名称，H_Phone，C_Phone，W_Phone，地址，城市，州，Pin_code，P_Email，W_Email，性别） ，生日，婚姻）价值观（@ Title，@ Name，@ H_Phone，@ C_Phone，@ W_Phone，@ Address，@ City，@ State，@ Pin_code，@ P_Email，@ W_Email，@ Gender，@ Birthday，@ Marriage） ，con）;

con.Open（）;

cmd.Parameters.AddWithValue（@ Title，this.TitalcomboBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Name，this。 NametxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ H_Phone，this.HPtxtBox.Text.Trim（））;

cmd.Parameters .AddWithValue（@ C_Phone，this.CPtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ W_Phone，this.WPtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Address，this.AddrstxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ City，this。 CitytxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ State，this.StatecomboBox.Text.Trim（））;

cmd.Parameters .AddWithValue（@ Pin_code，this.PintxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ P_Email，this.PEmailtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ W_Email，this.WEmailtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Gender，this。 GendrcomboBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Birthday，this.dateTimePicker1.Value）;

cmd.Parameters.AddWithValue（@ Marriage，this.dateTimePicker2.Value）;

cmd.ExecuteNonQuery（）;

con.Close（）;

MessageBox.Show（记录成功插入）;

DisplayData（）;

ClearData（）;

}

其他

{

MessageBox.Show（请提供详情！）;

}

}



//在Listview中显示数据

private void DisplayData（）

{

listView1.View = View.Details;

SqlDataAdapter ada = new SqlDataAdapter（选择ID，标题，名称，来​​自TDContact的地址，con）;

DataTable dt = new DataTable（）;

ada.Fill（dt）;

listView1.Items.Clear（）;

foreach（dt.Rows中的DataRow行）

{

ListViewItem item = new ListViewItem（row [ID]。ToString（））;

item.SubItems.Add（row [Title]。ToString（）） ;

item.SubItems.Add（row [Name]。ToString（））;

item.SubItems.Add（row [Address]。ToString（ ））;

listView1.Items.Add（item）;

}

}



//清除数据

private void ClearData（ ）

{

TitalcomboBox.Text =;

NametxtBox.Text =;

HPtxtBox。 Text =;

CPtxtBox.Text =;

WPtxtBox.Text =;

AddrstxtBox.Text =;

CitytxtBox.Text =;

StatecomboBox.Text =;

PintxtBox.Text =;

PEmailtxtBox.Text =;

WEmailtxtBox.Text =;

GendrcomboBox.Text =;

dateTimePicker1。 Text =;

dateTimePicker2.Text =;

ID = 0;

}

< br $>
//更新记录

private void btn_Update_Click_1（对象发件人，EventArgs e）

{

cmd =新的SqlCommand（更新TDContact设置标题= @标题，名称= @名称，H_Phone = @ H_Phone，C_Phone = @ C_Phone，W_Phone = @ W_Phone，地址= @地址，城市= @ City，State = @ State，Pin_code = @Pin_code，P_Email = @ P_Email，W_Email = @ W_Email，Gender = @ Gender，Birthday = @ Birthday，Marriage = @ Marriage where tdtext = @id，con）;

con.Open（）;

cmd.Parameters.AddWithValue（@ id，tdtext）;

cmd.Parameters.AddWithValue（@ Title ，this.TitalcomboBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Name，this.NametxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ H_Phone，this.HPtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ C_Phone，this.CPtxtBox.Text.Trim（ ））;

cmd.Parameters.AddWithValue（@ W_Phone，this.WPtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Address ，this.AddrstxtBox.Te xt.Trim（））;

cmd.Parameters.AddWithValue（@ City，this.CitytxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue （@ State，this.StatecomboBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ Pin_code，this.PintxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ P_Email，this.PEmailtxtBox.Text.Trim（））;

cmd.Parameters.AddWithValue（@ W_Email，this.WEmailtxtBox。 Text.Trim（））;

cmd.Parameters.AddWithValue（@ Gender，this.GendrcomboBox.Text.Trim（））;

cmd.Parameters.AddWithValue （@ Birthday，this.dateTimePicker1.Value）;

cmd.Parameters.AddWithValue（@ Marriage，this.dateTimePicker2.Value）;

int k = cmd.ExecuteNonQuery（）;

con.Close（）;

if（k> 0）

{

MessageBox.Show（记录成功更新）;

DisplayData（）;

ClearData（）;

}

else

{

MessageBox.Show（请选择要更新的记录） ）;

}

}



//选择Listview索引

私人void listView1_SelectedIndexChanged（object sender，EventArgs e）

{



if（listView1.SelectedItems.Count == 0）

return;

ListViewItem item = listView1.SelectedItems [0];

ID = Convert.ToInt32（listView1.SelectedItems [0] .SubItems [0] .Text ）;



TitalcomboBox.Text = listView1.SelectedItems [0] .SubItems [1] .Text;

NametxtBox.Text = listView1.SelectedItems [0] .SubItems [2] .Text;

//HPtxtBox.Text = listView1.SelectedItems [0] .SubItems [3] .Text;

//CPtxtBox.Text = listView1.SelectedItems [0] .SubItems [4] .Text;

//WPtxtBox.Text = listView1.SelectedItems [0] .SubItems [5]。文字;

//AddrstxtBox.Text = listView1.SelectedItems [0] .SubItems [6] .Text;

//CitytxtBox.Text = listView1.SelectedItems [0] .SubItems [7] .Text;

//StatecomboBox.Text = listView1.SelectedItems [0] .SubItems [8] .Text;

//PintxtBox.Text = listView1.SelectedItems [0] .SubItems [9] .Text;

//PEPEtxtBox.Text = listView1.SelectedItems [0] .SubItems [10] .Text;

//WEmailtxtBox.Text = listView1.SelectedItems [0] .SubItems [11] .Text;

// GendrcomboBox.Text = listView1.SelectedItems [0] .SubItems [12] .Text;

// dateTimePicker1。 Text = listView1.SelectedItems [0] .SubItems [13] .Text;

//dateTimePicker2.Text = listView1.SelectedItems [0] .SubItems [14] .Text;

}



//删除记录

private void btn_Delete_Click_1（对象发件人，EventArgs e）

{

if（ID！= 0）

{

cmd = new SqlCommand（删除TDContact，其中tdtext = @ id，con）;

con.Open（）;

cmd.Parameters.AddWithValue（@ id，tdtext）;

cmd.ExecuteNonQuery（）;

con.Close（）;

MessageBox.Show（Record Deleted Successfully！）;

DisplayData（）;

ClearData（）;

}

else

{

MessageBox.Show（请选择记录删除）;

}

}





//隐藏TextBox onclick事件

private void tdtext_TextChanged（object sender，EventArgs e）

{





SqlDataAdapter ada = new SqlDataAdapter（select ID ，标题，名称，H_Phone，C_Phone，W_Phone，地址，城市，州，Pin_code，P_Email，W_Email，性别，生日，婚姻来自TDContact，其中ID ='+ tdtext.Text +'，con）;





}



// private void txt_SearchName_TextChanged（object sender，EventArgs e）

// {

// if（txt_SearchName.Text！=）{

// for（int i = listView1.Items。数 - 1; i> = 0;我 - ）{

// var item = listView1.Items [i];

// if（item.Text.ToLower（）。包含（txt_SearchName.Text .ToLower（）））{

// item.BackColor = SystemColors.Highlight;

// item.ForeColor = SystemColors.HighlightText;

//}

// else {

// listView1.Items.Remove（item）;

//}

//}

// if（listView1.SelectedItems.Count == 1）{

// listView1.Focus（）;

//}

//}

//其他

// DisplayData（）;



//}



}

}



我的尝试：



不存在地图从对象类型System.Windows.Forms.TextBox到已知的托管提供者本机类型。

namespace TDApplication
{
public partial class Contactform : Form
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=TDApplication;Integrated Security=true;");
SqlCommand cmd;

//ID variable used in Updating and Deleting Record
int ID = 0;
//int ID = @tdtext;
//int ID = tdtext.Text;

public Contactform()
{
InitializeComponent();
DisplayData();
ClearData();
}

//Insert Data
private void btn_Insert_Click(object sender, EventArgs e)
{
if (TitalcomboBox.Text != "" && NametxtBox.Text != "")
{
cmd = new SqlCommand("insert into TDContact ( Title,Name,H_Phone,C_Phone,W_Phone,Address,City,State,Pin_code,P_Email,W_Email,Gender,Birthday,Marriage) VALUES (@Title,@Name,@H_Phone,@C_Phone,@W_Phone,@Address,@City,@State,@Pin_code,@P_Email,@W_Email,@Gender,@Birthday,@Marriage)", con);
con.Open();
cmd.Parameters.AddWithValue("@Title", this.TitalcomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Name", this.NametxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@H_Phone", this.HPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@C_Phone", this.CPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@W_Phone", this.WPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@Address", this.AddrstxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@City", this.CitytxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@State", this.StatecomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Pin_code", this.PintxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@P_Email", this.PEmailtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@W_Email", this.WEmailtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@Gender", this.GendrcomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Birthday", this.dateTimePicker1.Value);
cmd.Parameters.AddWithValue("@Marriage", this.dateTimePicker2.Value);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Provide Details!");
}
}

//Display Data in Listview
private void DisplayData()
{
listView1.View = View.Details;
SqlDataAdapter ada = new SqlDataAdapter("select ID, Title,Name,Address from TDContact", con);
DataTable dt = new DataTable();
ada.Fill(dt);
listView1.Items.Clear();
foreach (DataRow row in dt.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["Title"].ToString());
item.SubItems.Add(row["Name"].ToString());
item.SubItems.Add(row["Address"].ToString());
listView1.Items.Add(item);
}
}

//Clear Data
private void ClearData()
{
TitalcomboBox.Text = "";
NametxtBox.Text = "";
HPtxtBox.Text = "";
CPtxtBox.Text = "";
WPtxtBox.Text = "";
AddrstxtBox.Text = "";
CitytxtBox.Text = "";
StatecomboBox.Text = "";
PintxtBox.Text = "";
PEmailtxtBox.Text = "";
WEmailtxtBox.Text = "";
GendrcomboBox.Text = "";
dateTimePicker1.Text = "";
dateTimePicker2.Text = "";
ID = 0;
}

//Update Record
private void btn_Update_Click_1(object sender, EventArgs e)
{
cmd = new SqlCommand("update TDContact set Title=@Title,Name=@Name,H_Phone=@H_Phone,C_Phone=@C_Phone,W_Phone=@W_Phone,Address=@Address,City=@City,State=@State,Pin_code=@Pin_code,P_Email=@P_Email,W_Email=@W_Email,Gender=@Gender,Birthday=@Birthday,Marriage=@Marriage where tdtext = @id ", con);
con.Open();
cmd.Parameters.AddWithValue("@id", tdtext);
cmd.Parameters.AddWithValue("@Title", this.TitalcomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Name", this.NametxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@H_Phone", this.HPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@C_Phone", this.CPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@W_Phone", this.WPtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@Address", this.AddrstxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@City", this.CitytxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@State", this.StatecomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Pin_code", this.PintxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@P_Email", this.PEmailtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@W_Email", this.WEmailtxtBox.Text.Trim());
cmd.Parameters.AddWithValue("@Gender", this.GendrcomboBox.Text.Trim());
cmd.Parameters.AddWithValue("@Birthday", this.dateTimePicker1.Value);
cmd.Parameters.AddWithValue("@Marriage", this.dateTimePicker2.Value);
int k = cmd.ExecuteNonQuery();
con.Close();
if (k > 0)
{
MessageBox.Show("Record Updated Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Update");
}
}

// Select Listview Index
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{

if (listView1.SelectedItems.Count == 0)
return;
ListViewItem item = listView1.SelectedItems[0];
ID = Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text);

TitalcomboBox.Text = listView1.SelectedItems[0].SubItems[1].Text;
NametxtBox.Text = listView1.SelectedItems[0].SubItems[2].Text;
//HPtxtBox.Text = listView1.SelectedItems[0].SubItems[3].Text;
//CPtxtBox.Text = listView1.SelectedItems[0].SubItems[4].Text;
//WPtxtBox.Text = listView1.SelectedItems[0].SubItems[5].Text;
//AddrstxtBox.Text = listView1.SelectedItems[0].SubItems[6].Text;
//CitytxtBox.Text = listView1.SelectedItems[0].SubItems[7].Text;
//StatecomboBox.Text = listView1.SelectedItems[0].SubItems[8].Text;
//PintxtBox.Text = listView1.SelectedItems[0].SubItems[9].Text;
//PEmailtxtBox.Text = listView1.SelectedItems[0].SubItems[10].Text;
//WEmailtxtBox.Text = listView1.SelectedItems[0].SubItems[11].Text;
//GendrcomboBox.Text = listView1.SelectedItems[0].SubItems[12].Text;
//dateTimePicker1.Text = listView1.SelectedItems[0].SubItems[13].Text;
//dateTimePicker2.Text = listView1.SelectedItems[0].SubItems[14].Text;
}

//Delete Record
private void btn_Delete_Click_1(object sender, EventArgs e)
{
if (ID != 0)
{
cmd = new SqlCommand("delete TDContact where tdtext=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", tdtext);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Deleted Successfully!");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}


// hidden TextBox onclick event
private void tdtext_TextChanged(object sender, EventArgs e)
{


SqlDataAdapter ada = new SqlDataAdapter("select ID, Title,Name,H_Phone,C_Phone,W_Phone,Address,City,State,Pin_code,P_Email,W_Email,Gender,Birthday,Marriage from TDContact Where ID = '"+ tdtext.Text+"' ", con);


}

//private void txt_SearchName_TextChanged(object sender, EventArgs e)
//{
// if (txt_SearchName.Text != "") {
//for(int i = listView1.Items.Count - 1; i >= 0; i--) {
// var item = listView1.Items[i];
// if (item.Text.ToLower().Contains(txt_SearchName.Text.ToLower())) {
// item.BackColor = SystemColors.Highlight;
// item.ForeColor = SystemColors.HighlightText;
// }
// else {
// listView1.Items.Remove(item);
// }
// }
// if (listView1.SelectedItems.Count == 1) {
// listView1.Focus();
// }
// }
// else
// DisplayData();

// }

}
}

What I have tried:

No mapping exists from object type System.Windows.Forms.TextBox to a known managed provider native type.

推荐答案

因为tdtext是一个文本框：

Because tdtext is a textbox:
SqlDataAdapter ada = new SqlDataAdapter("select ID, Title,Name,H_Phone,C_Phone,W_Phone,Address,City,State,Pin_code,P_Email,W_Email,Gender,Birthday,Marriage from TDContact Where ID = '"+ tdtext.Text+"' ", con);

你不能把它传递给SQL：

you can't just pass it to SQL:

cmd.Parameters.AddWithValue("@id", tdtext);



您需要传递其Text属性：


You need to pass its Text property:

cmd.Parameters.AddWithValue("@id", tdtext.Text);





并删除字符串连接！无论你多久使用它都很危险！



And remove the string concatenation! That is dangerous regardless of how infrequently you use it!


这篇关于我如何...从对象类型system.windows.forms.textbox到已知的托管提供程序本机类型不存在映射。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆