اهلين اخواتى ارجو منكم المسا عده للعندهم خبره فى الفيجول بيسك دوت نت
I designed datagrid in Form Called Edite/Update which shows one table. It is solely based on the dataset. I want to make changes on datagrid and when I click save button. All the updates should be saved to database. I am using the following code but it is not working........
The if condition is never true. It says that there are not changes in the dataset but I changed the values on datagrid ( which is based on dataset)
If dsSpecialistCompanies1.HasChanges(DataRowState.Modified) Then
dsSpecialistCompanies1.AcceptChanges()
( daSpecialistCompanies1.Update(ds.Tables(0))
End If
how can i solve this problem
ارجو المساعده با قرب وقت لاان هذا البحث مهم جدا
TITNK @titnk
عضوة نشيطة
يلزم عليك تسجيل الدخول أولًا لكتابة تعليق.
السلام عليكم ورحمة الله وبركاته
بالنسبة للسؤال الثاني فبالsql ... ما يفرق الأكسس عن أي قاعدة بيانات أخرى فيمكن إضافة rows بالsql
هذا مثال بالC#:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Samples\\Employee.mdb";
OleDbConnection myConnection = new OleDbConnection( connectionString );
myConnection.Open();
string query = "insert into EMPLOYEE_TABLE (EmployeeID, Name, Address)
VALUES (101, 'John', '3960 CliffValley Way')";
OleDbCommand myCommand = new OleDbCommand();
myCommand.CommandText = query;
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();
myConnection.Close();
تمنياتي لك بالتوفيق
TITNK
•
اختى بارقة خير يريت توضحى لى الطريقه با الفيجول بيساك دوت نت فى اقرب وقت بطريقه واظحه لاا اننى جديده فى هذا المجال لاان الطريقه ليى بعتيها لغة اس ب دوت نت ليست اللغه التى اريدها يريت بطريقه مفصله ولكى جزيل الشكر
TITNK
•
ِi have ASP.NET a web form from VB.NET that gathers CompanyName,Addresslin1,Addressline2 ,TelephoneNO, State ,EmailAddress,WebSite,Pice,CreditCardNo,NameOnCard,etc. These are text boxes and those are the names I used for the textboxes.
I have want to make the connection to the database, so which connection that has to be used and how
At the bottom of the form is a button to submit. I would like to use that to insert the information into an Access database where the table is called SpecialistCompanies and the fields are: CompanyName,Addressline1,Addressline2,TelephoneNO,State ,EmailAddress,WebSite,Pice,CreditCardNo,NameOnCard,etc.
I have found many examples showing how to insert, and more for SQL but not for Access. In addition, all I really need is to insert. I don't need to delete.
some help would be appreciated.
thanks in Advanc
I have want to make the connection to the database, so which connection that has to be used and how
At the bottom of the form is a button to submit. I would like to use that to insert the information into an Access database where the table is called SpecialistCompanies and the fields are: CompanyName,Addressline1,Addressline2,TelephoneNO,State ,EmailAddress,WebSite,Pice,CreditCardNo,NameOnCard,etc.
I have found many examples showing how to insert, and more for SQL but not for Access. In addition, all I really need is to insert. I don't need to delete.
some help would be appreciated.
thanks in Advanc
الصفحة الأخيرة
I have ِASP.NET a web form from VB.NET that gathers CompanyName,Addresslin1,Addressline1 ,TelephoneNO,etc. These are text boxes and those are the names I used for the textboxes.
I have already made the connection to the database, created the sqldataadapter and the data adapter.
At the bottom of the form is a button to submit. I would like to use that to insert the information into an Access database where the table is called SpecialistCompanies and the fields are: CompanyName,Addressline1,Addressline2,TelephoneNO,State ,etc.
I have found many examples showing how to insert, and more for SQL but not for Access. In addition, all I really need is to insert. I don't need to delete.
some help would be appreciated.
thanks in Advance