Hi Unity Members,
In my project I am trying to create sqlClass to connect Microsoft sql server.
I have develop my class to some extend. For example, I can query data according to input of textbox. However, I am doning this query without using any paramater because it gives error.
Part of my code–>
public class SqlClass{
string connectionString = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=EPTT;User ID=eptt; Password=123; Trusted_Connection=False; ";
SqlConnection cnn = new SqlConnection();
public SqlClass()
{
cnn.ConnectionString = connectionString;
}
public DataTable Fill(string sql, params SqlParameter[] prms)
{//with parameter
SqlCommand cmd = new SqlCommand(sql, cnn);
if (prms != null)
{
cmd.Parameters.AddRange(prms);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
public DataTable Fill(string sql)
{//without parameter
SqlCommand cmd= new SqlCommand(sql,cnn);
SqlDataAdapter da= new SqlDataAdapter(cmd);
DataTable dt= new DataTable();
int dene=da.Fill(dt);
return dt;
}
}
as you can see two types of my query functions. The firs one contain
cmd.Parameters.AddRange(prms); line. This line AddRange is unknown in unity (In .Net web apllication this class run without any problem). Therefore, I use Add instead of AddRange but this time it gives error “InvalidCastException:The parameter was not an SqlParameter”
could you help me, I will be glad to read your ideas.
Tnx,