C#

myCommand.Parameters.Add("@s_fiyat",SqlDbType.Float);
myCommand.Parameters["@s_fiyat"].Value =(bırım_fıyatı.Text);

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

myCommand.Parameters.Add("@i_cesit",SqlDbType.VarChar);
myCommand.Parameters["@i_cesit"].Value = ıplık_cesıtı.Text;
myCommand.Parameters.Add("@i_uzunluk",SqlDbType.Int);
myCommand.Parameters["@i_uzunluk"].Value = ıplık_capı.Text;
myCommand.Parameters.Add("@i_capı",SqlDbType.VarChar);
myCommand.Parameters["@i_capı"].Value = ıplık_capı.Text;
myCommand.Parameters.Add("@i_uzunlugu",SqlDbType.Int);
myCommand.Parameters["@i_uzunlugu"].Value = (ıgne_uzunlugu.Text);
myCommand.Parameters.Add("@i_kavisi",SqlDbType.VarChar);
myCommand.Parameters["@i_kavisi"].Value = ıgne_kavısı.Text;
myCommand.Parameters.Add("@arayuz",SqlDbType.VarChar);
myCommand.Parameters["@arayuz"].Value = ara_yuzu.Text;
myCommand.Parameters.Add("@kod",SqlDbType.VarChar);
myCommand.Parameters["@kod"].Value = urun_kodu.Text;
myCommand.Parameters.Add("@stok",SqlDbType.Int);
myCommand.Parameters["@stok"].Value = (stok_mıktarı.Text).ToString();
myCommand.Parameters.Add("@g_fiyat",SqlDbType.Float);
myCommand.Parameters["@g_fiyat"].Value = (bırım_fıyatı.Text);
myCommand.Parameters.Add("@s_fiyat",SqlDbType.Float);
myCommand.Parameters["@s_fiyat"].Value =(bırım_fıyatı.Text);
myCommand.ExecuteNonQuery();

<br />
		private string CreaClase(System.Data.DataRow row)<br />
		{<br />
			string codigo = @"<br />
using System;<br />
using System.Data;<br />
<br />
namespace miNamespace {<br />
public class miClase {<br />
<br />
	public miClase(System.Data.DataRow row)<br />
	{<br />
		m_Row = row;<br />
";<br />
			foreach(System.Data.DataColumn col in row.Table.Columns)<br />
			{<br />
				codigo += "\t\tif(row[\"" + col.ColumnName + "\"] != DBNull.Value)\n";<br />
				codigo += "\t\t{\n";<br />
				codigo += "\t\t\tthis." + col.ColumnName + " = (" + col.DataType.UnderlyingSystemType.ToString() + ")row[\"" + col.ColumnName + "\"];\n";<br />
				codigo += "\t\t}\n";<br />
			}<br />
	codigo += "}\n";<br />
			foreach(System.Data.DataColumn col in row.Table.Columns)<br />
			{<br />
				string campo = col.DataType.UnderlyingSystemType.ToString() + " m_" + col.ColumnName;<br />
				string propiedad = col.DataType.UnderlyingSystemType.ToString() + " " + col.ColumnName;<br />
				codigo +=  "private " + campo  + ";\n";<br />
				codigo += @"<br />
	public " + propiedad + @"<br />
	{<br />
		get { return m_" + col.ColumnName + @"; }<br />
		set { <br />
				m_" + col.ColumnName + @" = value;";<br />
				codigo += "m_Row[\"" + col.ColumnName + "\"] = value;";<br />
				codigo += @"<br />
			}<br />
	}<br />
<br />
	";<br />
			}<br />
<br />
			codigo += @"<br />
	private System.Data.DataRow m_Row;<br />
	public System.Data.DataRow miMethod()<br />
	{<br />
		return m_Row;<br />
	}<br />
<br />
";<br />
			codigo +="}    }";<br />
<br />
			return codigo;<br />
		}<br />
<br />
		private void CreaObjeto(string codigo)<br />
		{<br />
			ICodeCompiler compilador = new CSharpCodeProvider().CreateCompiler();<br />
			CompilerParameters parametros = new CompilerParameters();<br />
<br />
			parametros.ReferencedAssemblies.Add("System.dll");<br />
			parametros.ReferencedAssemblies.Add("System.Data.dll");<br />
<br />
			parametros.GenerateInMemory = true;<br />
			<br />
			CompilerResults compilado = compilador.CompileAssemblyFromSource(parametros,codigo);<br />
<br />
			if (compilado.Errors.HasErrors) <br />
			{<br />
				string mensaje = "";<br />
<br />
				mensaje = compilado.Errors.Count.ToString() + " Errores:";<br />
				for (int x=0;x<compilado.Errors.Count;x++) <br />
					mensaje = mensaje  + "\r\nLine: " + compilado.Errors[x].Line.ToString() + " - " + <br />
						compilado.Errors[x].ErrorText;		<br />
<br />
				MessageBox.Show(mensaje + "\r\n\r\n" + codigo,"Error",MessageBoxButtons.OK,MessageBoxIcon.Error);<br />
<br />
				return;<br />
			}<br />
<br />
			Assembly ensambaldo = compilado.CompiledAssembly;<br />
<br />
			this.Objeto  = ensambaldo.CreateInstance("miNamespace.miClase",true,BindingFlags.CreateInstance,null,new object[]{this.DS.Tables[0].Rows[0]},System.Globalization.CultureInfo.CurrentCulture,null);<br />
			if (this.Objeto == null) <br />
			{<br />
				MessageBox.Show("No se pudo cargar la clase!.");<br />
				return;<br />
			}<br />
		}<br />
				private void frmParametro_Load(object sender, System.EventArgs e)<br />
		{<br />
			CreaObjeto(CreaClase(this.DS.Tables[0].Rows[0]));<br />
			this.propertyGrid1.SelectedObject = this.Objeto;<br />
		}<br />