Showing connection string in textfield

yes, ok. Sorry for that. Ofcourse you select first and then the connectionstring

HI,

I have it now like this:

This is my search query:

 public void rep_bind()
        {

            DataClasses1DataContext context = new DataClasses1DataContext(_connectionString);
           //_connectionString = txtConnectionString.Text;

            var selectTrip = (from t in context.TripElements
                                where (t.TripElementCode == textBox1.Text.Trim() || t.SegmentTypeCode == textBox1 .Text.Trim()
                                )
                                select new
                                {
                                    TripElementID = t.TripElementID,
                                    SegmentTypeCode = t.SegmentTypeCode,
                                    TripElementCode = t.TripElementCode,
                                    tripElementName = t.TripElementName
                                }).ToList();

          

            dataGridView1.DataSource = selectTrip;
            textBox1.Text = "";
        }

and this is listbox with all the connectionstrings:



[code]
 private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            _connectionString = txtConnectionString.Text;
            string selected = (string)listBox1.SelectedItem;
            XmlDocument docHallo = new XmlDocument();
            docHallo.Load(@"C:/Users/IllesIuliu/Documents/Visual Studio 2010/Projects/WindowsFormsApplication18/GetSelectedID/XML/Configurations.xml");
            XmlNodeList nodeList = docHallo.GetElementsByTagName("SupplyXMLConnectionString");
            txtConnectionString.Text = nodeList.Item(listBox1.SelectedIndex).InnerText;

           
        }
[/code]


and this is for my connectionstring:

private string loadConnectionString;
        private string _connectionString;// = @"server=DEV12;database=prod_CycleTours_net2_backup_201107110300;uid=sa;pwd=misoft;";

But so If I remove the hardcoded connectionstring then I get this error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

But if I do it hardcoded then it works.

No, I mean change:

YOu mean change this:

 private string _connectionString = @"server=DEV12;database=acceptance_primavera_net2_r0713;uid=sa;pwd=Misoft;";

to this:

  private string _connectionString = txtConfigurationName.Text;

HI,

I am using LINQ, like this:

public void hallo()
        {
            DataClasses1DataContext context = new DataClasses1DataContext(_connectionString);
            var ok = from t in context.TripElements
                     where SqlMethods.Like(t.TripElementName, "%" + t.TripElementName.Contains(textBox1.Text.Trim())

                     )
                     select new
                            {
                                TripElementID = t.TripElementID,
                                SegmentTypeCode = t.SegmentTypeCode,
                                TripElementCode = t.TripElementCode,
                                tripElementName = t.TripElementName
                            };

            dataGridView1.DataSource = ok;
            textBox1.Text = "";

It should be just a matter of setting your _connectionString field:

_connectionString = txtConfigurationName.Text;

and then calling whatever method you call now to open the connection and load the database with the appropriate table.

Hi,

THX. It works now. But can you help me with other tread. That if you select and connectionstring that the database will automatically be loaded with a specific table - in this case: TripElement. Because I have it now hard coded, like this:

private string _connectionString = @"server=DEV12;database=prod_CycleTours_net2_backup_201107110300;uid=sa;pwd=misoft;";

OK, try this instead:

txtConfigurationName.Text = nodeList.Item(listBox1.SelectedIndex).InnerText;

yes,

here is the xml:

prod_Bizztravel1808 DEV12
    server=DEV12;database=prod_Bizztravel1808;uid=sa;pwd=misoft;

and so I have a listbox with the Name and then you can select the name in the listbox and then the associated SupplyXMLConnectionString will be shown in the TextBox.

Can you give me an example of what a "SupplyXMLConnectionString" node looks like in the XML file? 

Hi thx,

for your replay.

I have it now like this:

private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string selected = (string)listBox1.SelectedItem;
            XmlDocument docHallo = new XmlDocument();
            docHallo.Load(@"C:/Users/IllesIuliu/Documents/Visual Studio 2010/Projects/WindowsFormsApplication18/GetSelectedID/XML/Configurations.xml");
            XmlNodeList nodeList = docHallo.GetElementsByTagName("SupplyXMLConnectionString");
            txtConfigurationName.Text = nodeList.Item(listBox1.SelectedIndex).Value;

           
        }

but I dont see anything in the textbox when I select a item from the dropdownlist.

In your original code, try:

 txtConfigurationName.Text = nodeList.Item(listBox1.SelectedIndex).Value;

And if I try this:

private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            XmlDocument docHallo = new XmlDocument();
            docHallo.Load(@"C:/Users/IllesIuliu/Documents/Visual Studio 2010/Projects/WindowsFormsApplication18/GetSelectedID/XML/Configurations.xml");
            XmlNodeList nodeList = docHallo.GetElementsByTagName("SupplyXMLConnectionString");

           

               // if (listBox1.SelectedIndex == 1)
            txtConfigurationName.Text = nodeList.ToString(); //  listBox1.SelectedItem(node.InnerText).ToString();
        }

Then I see in the textbox:

System.Xml.XmlElementList

I try something like this:

 foreach (XmlNode node in nodeList)
    {

  if (listBox1.SelectedIndex == 1)
  txtConfigurationName.Text = listBox1.Items.Add(node.InnerText);
 
     
    }

For testing.

But then I get this error: