Thanks for ur response . I am very grateful 2 u there r 2 problems now how to create stored procedures in MS ACCESS 2007? when I searched it over GOOGLE, there was a button to create stored procedure in the CREATE beside the query design and query wizard but that option is not available in the copy I am running on my pc? secondly due to security risks some of the content is disabled which prevents me from updating the database such as password of a particular user when I run the update query but as soon as i enabled the content , it allows me to run the update query. when i close the database the settings are again disable which restrict me to update my database through application. :confused::confused::confused::confused: I hv no clue how to overcome this problem Kindly provide me with ur assistance. Thanks

Sadaf

there is one thing I forgot to mention which is that once the query to retrieve the data from database is decided (string command is formed) , I call the GetData function passing it the string command GetData(command); Kidnly correct me if you think this can done in other ways!

Sadaf

Thanks for ur co-operation but let me briefly describe what i want my query is changing based on the filters used . to accomodate this situation , i have made a function GetData() which is being called after the user clicks on the button (btnFind) and they query is decided based on the filters specified by the user which means the parameters also change . ---Function GetData()---- private void GetData(string selectCommand) { // Specify a connection string. Replace the given value with a // valid connection string for a Northwind SQL Server sample // database accessible to your system. string currentDirectory = System.Environment.CurrentDirectory; OleDbConnection con = new OleDbConnection(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + currentDirectory + "\\dbLetters.mdb';Persist Security Info=False"; // Create a new data adapter based on the specified query. dataAdapter= new OleDbDataAdapter(selectCommand, con); // Create a command builder to generate SQL update, insert, and // delete commands based on selectCommand. These are used to // update the database. OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter); // Populate a new data table and bind it to the BindingSource. DataTable table = new DataTable(); table.Locale = System.Globalization.CultureInfo.InvariantCulture; dataAdapter.Fill(table); bindingSource1.DataSource = table; // Resize the DataGridView columns to fit the newly loaded content. dataGridView1.AutoResizeColumns( DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader); dataGridView1.DataSource = bindingSource1; } -------END-------- -----query specified----- string command = ""; #region Sender of the letter is specified else if (chkFrom.Checked == true && chkDate.Checked == false && chkSubject.Checked == false) { if (cmbFrom.SelectedItem.ToString() == "Others") { command = "Select * from tblIncomingLetters where From LIKE ='" + this.txtFrom.Text+ "'"; } else

Hello friends, I am trying to write a query to bring records from my ACCESS database and the field type of the column included in the where clause is date/time. my query was: command = "Select * FROM tblIncomingLetters where InwardDate Between " + dateTimePicker1.Value.Date+ " AND " + dateTimePicker2.Value.Date; I am sending this query to another fucntion that will take this query as a command txt but it is constantly giving me the error of missing operator I was wondering if anyone of you can help me in resolving the issue. Looking forward for your input.

Sadaf

Thanks all for ur kind help but its still giving the same error!

Sadaf

Hello friends in my windows form , there is a listbox which gets filled on the form load event. on the button click event, the item selected in the listbox is deleted from the database and message box appears telling that the this item has been removed from the database the problem is that I want that after the messagebox is closed, the list box should be refreshed now holding the items that are now currently in the databse and the item I have just deleted should not appear in the listbox. How will I achieve this? Looking forward for ur kind suggestions on the problem. Thanks

Sadaf

the code in my application is: OleDbCommand com = new OleDbCommand(); com.Connection = con; com.CommandText = "UPDATE tblUsers SET Password=? WHERE UserName=?"; com.Parameters.Add("UserName", OleDbType.WChar); com.Parameters.Add("Password", OleDbType.WChar); com.Parameters["UserName"].Value = this.UserName; com.Parameters["Password"].Value = this.txtPassword1.Text; ------------------------------------------------------------------------------- When I run the application , it gives the syntax error in update query. I am unable to find where I am going wrong Kindly help me!

Sadaf

Just wanted to know if there is any way to change the drop down arrow of the combobox in windows application using VS 2005 IDE

Sadaf

I have used crystal reports in C# .net in my application when I run my application on my client PC where Visual Studio 2005 IDE is not installed, the forms having crystal report do not display. The .net framework 2.0 has already been installed on the coimputers but I was wondering if there is any other also required to display crystal reports.

Sadaf

Actually I was not sure where it will be appropriate to place it however I needed help as soon as possible thus i placed i repeated the post to make sure that i get my answer i am sorry if u mind it and thank u so much 4 ur kind help :)

Sadaf

Hello friends I have created a windows application using C#.net and MS ACCESS Database which I have kept in the bin\debug folder along with the .exe file Bein novice to programming , I have no idea regarding deploying the windows application along with the database.:confused::confused: I would really apprecaite if you ppl help me out or provide with any reference that will help me in achieving my task. :-D Thanks in advance:rose:

Sadaf

Hi 2 all I have created a C#.Net windows application using the MS ACCESS database. I have placed this database in bin\debug folder along with .exe file:confused: The problem is that being novice to programming, I have no idea to deploy an application that involves a database. :(( :(( :(( I would really appreciate if my friends help me out Thanks in advance:rose:

Sadaf

EVERY TIME I OPEN THE SOLUTION FILE TO MAKE SOME CHANGES IN MY PROJECT , THE RECORDS ADDED AFTER USING ENVIRONMENT.CURRENTDIRECTORY ARE DELETED . HOWEVER THE RECORDS THAT WERE INSERTED INTO THE DATABASE BEFORE I USED THIS REMAIN AS IT IS. WHAT COULD BE THE CAUSE?:confused:

Sadaf

INSERT INTO tblOutgoingLetters ([To], [From], Subject, RefNumber, RefDate, OutwardNumber, OutwardDate, FileNumber, Remarks) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) this is the command that I have in the CommandText property of Command object..but instead of inserting a new record into the table , it is changing the content i.e. updating the last record Do u have any idea about why is this problem occurring?

Sadaf

thanks 4 ur kind help I tried it but not there is a 2nd problem which is as follows: my code is: string currentDirectory = System.Environment.CurrentDirectory; OleDbConnection con = new OleDbConnection(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + currentDirectory + "\\dbLetters.mdb';Persist Security Info=False"; this.oleDbInsertCommand1.Connection = con; //other parameters this.oleDbInsertCommand1.Parameters["Subject"].Value = this.txtSubject.Text; this.oleDbInsertCommand1.Parameters["RefNumber"].Value = this.txtRefNumber.Text; this.oleDbInsertCommand1.Parameters["RefDate"].Value = this.dateTimePicker1.Value; this.oleDbInsertCommand1.Parameters["OutwardNumber"].Value = this.txtOutwardNumber.Text; this.oleDbInsertCommand1.Parameters["OutwardDate"].Value = this.dateTimePicker2.Value; this.oleDbInsertCommand1.Parameters["FileNumber"].Value = this.txtFileNumber.Text; this.oleDbInsertCommand1.Parameters["Remarks"].Value = this.txtRemarks.Text; con.Open(); this.oleDbInsertCommand1.ExecuteNonQuery(); con.Close(); ------------------------------- Upon execution , it is not creating a new record but always updating the last record and I have no clue to why is this happening. :( Plz guide me . I shall be really thankful 2 u

Sadaf

Thanks a lot I will try it today :-D

Sadaf

I am really sorry if I sound rude but that was not my purpose to mark my post URGENT . the only purpose to do that was I have to show it to my supervisor and I just want the people to know that I want their help instantly but I AM REALLY VERY SORRY :( :( :( I will make sure it never happens again I am using MS ACCESS 2003... thanks 4 ur kind help

Sadaf

hello 2 all the problem that I am facing these days is that I am using oleDbConnection in my application. the database that I am using in my application resides in the solution folder. everytime I take this application to other computer, I have to change the connection string which I dont want to how can I overcome this problem. :(( :confused::confused::confused: I will appreciate if someone help me in resolving the issue. Thanks in advance :-D

Sadaf