Dynamic SQL Scripts

SqlConnection sql =new SqlConnection("Server=(local); User id=sa; Password=sa; Database=Friends");
sql.Open();
string sadsoyad="koray",smeslek="bilgisayar",yer="......",mail="i@",tel="2143234";
string sdogum="12.12.1987";
string id=textBox1.Text;
Dataset1 dataSet1=new Dataset1();
string sorgu="UPDATE ";
string tabloAd=dataSet1.Tables[1].TableName;
string set1=" SET";
string where=" WHERE ";
string update=" adSoyad='"+sadsoyad+"',meslek='"+smeslek+"',dogumTarihi='"+sdogum+"',yasadigiYer='"+yer+"',eMail='"+mail+"',telefon='"+tel+"' ";
string edilecek=" adSoyad='"+sadsoyad+"' ";
sorgu+=tabloAd;
sorgu+=set1;
sorgu+=update;
sorgu+=where;
sorgu+=edilecek;
textBox2.Text=sorgu ;
SqlCommand komut=new SqlCommand(sorgu,sql);
komut.ExecuteNonQuery();
sql.Close();
-------------------------------------------------------------------------------------------
SqlConnection sql=new SqlConnection("Server=(local); User id=sa; Password=sa; Database=Friends");
sql.Open();
Dataset1 ds=new Dataset1();
string adsoyad,meslek,yer,mail,tel,dogum;
adsoyad=textBox3.Text ;
meslek=textBox4.Text;
dogum="12.12.1985";
yer=textBox5.Text;
mail=textBox6.Text;
tel=textBox7.Text;
string sorgu="INSERT INTO ";
string tabloAd=ds.Tables[1].TableName;
sorgu+=tabloAd;
string ekle="(adsoyad,meslek,dogumTarihi,yasadigiYer,eMail,telefon)";
sorgu+=ekle;
string values=" VALUES ";
sorgu+=values;
string deger="('"+adsoyad+"','"+meslek+"','"+dogum+"','"+yer+"','"+mail+"','"+tel+"')";
sorgu+=deger;
listBox1.Items.Add(sorgu);


SqlCommand komutt=new SqlCommand(sorgu,sql);
komutt.ExecuteNonQuery();
sql.Close();
 

Bu blogdaki popüler yayınlar

About Android padding, margin, width, height, wrap_content, match_parent, R Class

Padding and Margin padding  and  layout_margin  are two very similar attributes. Both determine the space around a View. The difference is that  padding  determines space within the boundaries of the view, and  layout_margin  determines the space outside the boundaries of the view. Width and Height Some of the most important properties are the width property and height property - those must be defined for every view. Remember that all views occupy a rectangular area on the screen - the width and height are the width and height of that area. You can define this in pixels, or better yet dp (stands for density-independent pixels): android:layout_width="200dp" android:layout_height="300dp" For the sake of having a layout be responsive and adjust to different devices, two common values are not numbers at all, but  wrap_content  and  match_parent  used as shown here: android:layout_width="wrap_content" android:layout_height="match_parent"
Devamı

@SerializedName and @Expose annotations

The  @SerializedName  annotation is needed for Gson to map the JSON keys with our fields. In keeping with Java's camelCase naming convention for class member properties, it is not recommended to use underscores to separate words in a variable.  @SerializedName  helps translate between the two. @SerializedName ( "quota_remaining" ) @Expose private Integer quotaRemaining; In the example above, we are telling Gson that our JSON key  quota_remaining  should be mapped to the Java field  quotaRemaining .  If both of these values were the same, i.e. if our JSON key was  quotaRemaining  just like the Java field, then there would be no need for the  @SerializedName  annotation on the field because Gson would map them automatically. The  @Expose  annotation indicates that this member should be exposed for JSON serialization or deserialization. 
Devamı