110,566
社区成员
发帖
与我相关
我的任务
分享
create table tb(city varchar(50))
insert into tb select '日本'
insert into tb select '美国'
insert into tb select '印度'
alter function getname(@city varchar(50))
returns varchar(100)
as
begin
return '国家:中国---- 省份:'+@city
end
private void button1_Click(object sender, EventArgs e)
{
string Myconnection = "server=.;database=shui;uid=sa;pwd=nevertell;";
string sql = "select dbo.getname(city) as city from tb";
SqlConnection Myconn = new SqlConnection(Myconnection);
Myconn.Open();
SqlCommand STcmd = new SqlCommand(sql, Myconn);
SqlDataAdapter da = new SqlDataAdapter(sql, Myconn);
DataSet dt = new DataSet();
da.Fill(dt);
this.dataGridView1.DataSource = dt.Tables[0];
}