public static List<valuetext> GetProductExtendData(string key, string Color)
{
List<valuetext> list = new List<valuetext>();
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AdventureWorks"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT TOP 10 [ProductID],[Name] FROM [AdventureWorks].[Production].[Product] where Color='"+Color+"' AND Name like '%" + key + "%'";
SqlDataReader reader = null;
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
valuetext tt = new valuetext();
tt.text = reader["Name"].ToString();
tt.value = Int32.Parse(reader["ProductID"].ToString());
list.Add(tt);
}
}
finally
{
reader.Close();
reader = null;
con.Close();
}
return list;
}
public static List<valuetext> GetPerson()
{
List<valuetext> l = new List<valuetext>();
valuetext s = new valuetext() { text = "许志伟1", value = 1 };
l.Add(s);
valuetext s1 = new valuetext() { text = "许志伟2", value = 2 };
l.Add(s1);
valuetext s2 = new valuetext() { text = "许志伟3", value = 3 };
l.Add(s2);
return l;
}