SaveItem
How do I use Save Item
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
Line | Code | Ex.. |
---|---|---|
249 | newgrade = gradeclass.DataModule.SaveItem(); | 1 |
106 | public DataSet SaveItem() | 2 |
110 | public DataSet SaveItem(string sortfield) | 3 |
File name: Form1.cs
Copy
236 public void Button4_Click(System.Object sender, System.EventArgs e)
237 {
238
239 string strmessage = default(string);
240 DialogResult dgrResult;
241
242 strmessage = "Are you sure you want to save data?";
243 dgrResult = MessageBox.Show(strmessage, "Save data", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
244
245
246 if (dgrResult == System.Windows.Forms.DialogResult.Yes)
247 {
248
249 newgrade = gradeclass.DataModule.SaveItem();
250 }
251
252 }
File name: gradeclass.cs
Copy
106 public DataSet SaveItem()
107 {
108 return this.SaveItem("data1");
109 }
File name: gradeclass.cs
Copy
110 public DataSet SaveItem(string sortfield)
111 {
112
113 System.Data.OleDb.OleDbConnection conn = GetConnection();
114
115 try
116 {
117
118 string SQL = default(string);
119
120 SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121 System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142
143 conn.Open();
144 cmd.ExecuteNonQuery();
145 conn.Close();
146 MessageBox.Show("New data is Added!");
147
148 Form1.Default.TextBox1.Text = "";
149 Form1.Default.TextBox2.Text = "";
150 Form1.Default.TextBox3.Text = "";
151 Form1.Default.TextBox4.Text = "";
152 Form1.Default.TextBox5.Text = "";
153 Form1.Default.TextBox6.Text = "";
154 Form1.Default.TextBox7.Text = "";
155 Form1.Default.TextBox8.Text = "";
156 Form1.Default.TextBox9.Text = "";
157 Form1.Default.TextBox10.Text = "";
158 Form1.Default.TextBox11.Text = "";
159 Form1.Default.TextBox12.Text = "";
160 Form1.Default.TextBox13.Text = "";
161 Form1.Default.TextBox14.Text = "";
162 Form1.Default.TextBox15.Text = "";
163 Form1.Default.TextBox16.Text = "";
164 Form1.Default.TextBox17.Text = "";
165 Form1.Default.TextBox18.Text = "";
166 Form1.Default.TextBox19.Text = "";
167 Form1.Default.STUDID.Text = "";
168
169 RefreshDGV();
170
171 }
172 finally
173 {
174 conn.Close();
175 conn.Dispose();
176 }
177
178 return default(DataSet);
179 }
SaveItem 146 lượt xem
Gõ tìm kiếm nhanh...