Thanks for your quick reply, i'll try it Thanks again Nine

Hi All, I wonder if it is possible to insert data from excel cell to access database by using C#? I really need some information about this, could anyone provide me this? Thanks in advance Nine

I got it, thank you very much.

Thank you for your quick reply. It's very helpful for me, but can you give me more where to put Application.OpenForms in?

Hi all I’m having 2 problems in C# now. 1. I have a MDIParent form which loads the login form in the form_load event. From there I if the user login successfully, I want to enable all menu items on the menu bar. If the login is fail, I want to disable some menu items there too. This means I want to enable/disable a MdiParent’s element from a child form, please help me how to do that. 2. From question 1, when I want to open a form from the menu, I create an object then just show it like this. frmCustomer frmCus=new frmCustomer(); frmCus.MdiParent=this; frmCus.Show(); But the problem is while a Customer form is opening, when the Customer menu is clicked, it creates another Customer form for me. Is there any way to check weather the form is shown or not before showing it?

Hi all I'm faced to deverlop a program that sends a message from one form to another using Delegate and Event. I do know a little about Delegate but do not know about Event. I can't make them work together. Here is my exaple

Thank you for your answer, but what I wanted to know is how to join 2 tables in the same data set using data relation. I do know how to join 2 tables using sql's select command, but this one is not. Could you please point me out for this? Thanks

Hi all I have 2 tables in the same data set like this:

string sqlCus="select * from Customers";
string sqlOrder="select * from Orders";

SqlDataAdapter daCus=new SqlDataAdapter(sqlCus,conn);
SqlDataAdapter daOrder=new SqlDataAdapter(sqlOrder,conn);

DataSet ds=new DataSet();
daCus.Fill(ds,"Customers");
daOrder.Fill(ds,"Orders");

now I want to get the OrderID column in Orders table and ContactName (CustomerName) in the Customers table according to the CustomerID column in the Orders table then show both column in a DataGridView control, how to do that? note: not use stored procedure and Linq

Hi all I'm having a problem with delegate. In my project I have 2 forms, form1 and form2. From form1 I have a button there just for opening form2. And from form2 I have a text box there to enter an Int value. After getting a value from the text box I want to send it back to form1 and appear in a text box on form1. I do this with a delegate but I don't know if my way is the way you use to solve this problem or not. Here is my code:

Form1

public delegate void TestDelegate(int i); public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Form2 frmOpen = new Form2(); frmOpen.ShowDialog(); } public void GetValueA(int i) { textBox1.Text = i.ToString(); } }

Form2
public partial class Form2 : Form { public Form2() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { int b; b = Convert.ToInt32(textBox1.Text); Form1 frm1=new Form1(); TestDelegate td = new TestDelegate(frm1.GetValueA); td(b); Close(); } }

thanks

I have load an image to a picture box like here: MypicBox.Image=Image.FileName("D/foto1.jpeg") the pic is now displaying in the box, but how can I clear it now? thanks

Yes, I already checked it. When I sent the first parameter, I used this code: rpt.ParameterFields.GetItemByName("text").AddCurrentValue ("a") Now I want to send the second one with the same code above, it seems to replace the first one like here: rpt.ParameterFields.GetItemByName("text").AddCurrentValue ("b") The result is "b" Which I want a b Help me please.............

Is it possible to sent two parameters to the same field in Crystal Report? I have sent a parameter to a field in the report. Now I want to send the other one to the same field, but it replaces the first one. What I want is to send many parameters to show on the report. Is it possible to do that?

what if I don't want to replace the first value? I mean I want send a second value to the same field but in the second row Please help me, thank

I'm using vb6 with Crystal Report8.5 I have sent a value to the "?text" field like this: Dim rpt As New CrystalReport1 rpt.ParameterFields.GetItemByName("text").AddCurrentValue ("a") How can I send the second value to the same field? Thanks

hello...help me please!!!!!!!!!!!!!!! i'm waiting for your answers.............

Hi all On my project I have created a connection and have retrieved some data from the database by using a stored proc. Here is the code: string cnString = "Data Source=localhost;Initial Catalog=Northwind;User Id=MyName;Password=MyPassword"; SqlConnection cn = new SqlConnection(cnString); SqlCommand cmd = new SqlCommand("sp_Products", cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds,"Products"); The database is now storing in my dataset. But how can I send it to display on my reportviewer by using crystal report that comes with visual studio? Thanks advance

So after calling the stored proc, how to pass the result to the report control? Let's clear us more... Thanks

hi ASHRAFHAKIEM i don't understand either. let's post your question to get help againq

i'm having same problem too. for mine, i don't know how to pass a parameter to the stored procedure since i use different query in my crystal report object.