Searchable data printed in a readonly textbox and be applied to db

George Paroglou

I am having a form in which the user is typing a searchable data and I need his value to be printed in a read only textbox which will search for the specific data in my sql server database.

In order to create this typing and printing schedule can be done as string and how can this be searchable in my db?

Thanks in advanced

28 Replies

Know the answer? Post it — somebody with the same question will find it here.

George Paroglou15y ago
the article that I mentionted earlier seems not to work for me. I found this: http://www.c-sharpcorner.com/uploadfile/mosessaur/winformsdelegates09042006094826am/winformsdelegates.aspx which worked fine. Just in case anyone facing the same problem. cheers guys for your help
George Paroglou15y ago
I want to pass a value from the second form to the previous form (first form). In other words I want to upadate the first form with the data written in the second form. we are saying the same thing or not?
Ankit Nandekar15y ago
if u want to pass any value in next form's control first create object of that form in previous form and with the use of its object write passing value on its text .so if u want to pass value first create object of that form.
George Paroglou15y ago
ankit this bit of code is effected by a showdialog() statement? I am asking you cause in my project it doesn't give an error but it doesn't put the written text in my previous form. I tried with brand new textboxes or richTectBoxes but still nothing... Do you think this is happening because of the reverse way of printing?
Ankit Nandekar15y ago
yaa u forgot to write Text there .
welcome george
George Paroglou15y ago
It is working indeed...I forgot the .Text ...cheers ankit
Ankit Nandekar15y ago
i have made some changes in ur project now its working i m attaching ur project plz check
George Paroglou15y ago
I attatched the cleaned project...I think it gives the same error with the published example...
Ankit Nandekar15y ago
can i see ur code where u r getting error.
George Paroglou15y ago
the problem remains cause I want to pass over only one set of data fields and it doesn't seem to work in without both sets...

Ankit I tried your code and even if I made all variables from public to internal it has an error in my firsts form richTextBox:

Error 1 Cannot implicitly convert type 'string' to 'System.Windows.Forms.TextBox'
Sam Hobbs15y ago
So have you solved the problem causing the message "The type or namespace name 'IdentityUpdateEventArgs' could not be found (are you missing a using directive or an assembly reference?".
Ankit Nandekar15y ago
u have tried my code? if not then try itis passing richtextbox value to unother form's textbox.
George Paroglou15y ago
the copied code project is exaclty the same with the example (without change a comma). The only change is that I created only the first part of set section (not included the address part of code). As soon as I include the address part of code it works fine without an error.

Ankit I want to pass from a second form any typed data to its previous form. Its the same for the reverse way?
Sam Hobbs15y ago
For some reason the compiler cannot find the definition of IdentityUpdateEventArgs that you gave it. Are you sure that the namespace that IdentityUpdateEventArgs is in is the same as the rest of your project?
Ankit Nandekar15y ago
i think u want to pass one textbox value to unother text box which is in unother form.
to do this

on first forms show button click event (Form to which textbox value u want to pass to unother form,s Textbox)
write following code like if second form namd is Form3 then code will be

            Form3 obj = new Form3();
            obj.textBox1.Text = richTextBox1.Text;//textbox1 is the textbox name to which u want to show value of first form's textbox
            obj.Show();

Note: Do seconds Form's textbox Modifier property internal otherwise it will give error.
George Paroglou15y ago
but i have already included its definition as well

public class IdentityUpdateEventArgs : System.EventArgs
{

// add local member variable to hold text
private string mFirstName;private string mMiddleName;private string mLastName;

// class constructor
public IdentityUpdateEventArgs(string sFirstName, string sMiddleName, string sLastName)
{

this.mFirstName = sFirstName;this.mMiddleName = sMiddleName;this.mLastName = sLastName;
}
}
Sam Hobbs15y ago
The two lines of code that you posted that uses IdentityUpdateHandler does not define IdentityUpdateEventArgs.
George Paroglou15y ago
you probably mean this:

// add a delegate

public delegate void IdentityUpdateHandler(object sender, IdentityUpdateEventArgs e);// add an event of the delegate type

public event IdentityUpdateHandler IdentityUpdated;

I have already included it in my second form...

I tried to create a project absolutly the same as the example and it prints the same error. This error is dissapeared only as soon as the frmAddress.cs is created and I also include the code for the second's form passing data....isn't it strange?
Sam Hobbs15y ago
IdentityUpdateEventArgs is defined in the sample code in that article, so you are missing part of the sample code.
George Paroglou15y ago
I've read this article ( http://www.c-sharpcorner.com/UploadFile/scottlysle/PassData01142007013005AM/PassData.aspx) regarding the passing data between forms and I am facing the following problem:

Even if I am transforming this example in my c# project it produces an error in IdentityUpdateEventArgs of my main form

( Error 1 The type or namespace name 'IdentityUpdateEventArgs' could not be found (are you missing a using directive or an assembly reference?))

The following code is the one that marks as error

private void IdForm_ButtonClicked(object sender, IdentityUpdateEventArgs e)
{
// update the forms values from the event args
txtFirstName.Text = e.FirstName;
txtMiddleName.Text = e.MiddleName;
txtLastName.Text = e.LastName;
}

Any suggestions of what is wrong?
Sam Hobbs15y ago
If you want something more specific then you need to be more specific.
George Paroglou15y ago
cheers sam for your info.

anyone else something more specific?
Sam Hobbs15y ago
The TextBox and RichTextBox controls have a Text property. You will need a reference to the other form though and I don't know enough about your application to know how to do that. There are however articles in this web site that will help with that.
George Paroglou15y ago
just to take any typed text from a text box and place the value in a readonly richtextform of a second child form....
Sam Hobbs15y ago
There are many articles in this web site about forms too, some of which of which should show what you need. I am however not sure of the details of what you need to do.

What Jonathas shows is good but appears to not use parameters and for something like this it is better to use parameters.
George Paroglou15y ago
perhaps take it step by step...in order to take the user's typed data and printed in the previous form inside a read only richtextbox this can be done with string or just as int?

I try to use the following code...

private void toolStripButton2_Click(object sender, System.EventArgs e)

{
string Value;

Value = textBox1.Text;
}

but I don't know who to call the readonly richTextBox of another form and place into it the textBox1.Text
Jonathas Sucupira15y ago
Something like this maybe?
private void ReadOrderData()
   {

   string filter = textbox1.text;
   string queryString =
   "Select * from table where something like '%" + filter + "%';";

   using (SqlConnection connection =
   new SqlConnection("Your Connection"))
   {
   SqlCommand command =
   new SqlCommand(queryString, connection);


   try
   {
   connection.Open();

   SqlDataReader reader = command.ExecuteReader();

   // Call Read before accessing data.
   while (reader.Read())
   {
   textbox2.text = reader[0].ToString();
   }

   // Call Close when done reading.
   reader.Close();
   }
   catch (Exception ex)
   {
   Response.Write("This error occurred= " + ex.Message);
   }

   finally
   {
   connection.Close();
   command = null;

   }
   }

   }
Sam Hobbs15y ago
Go to the home page of this web site and search for articles about parameterized queries.