Hi Thommie, Its a method that retrieve data from the database. public DataTable Retrieve_Municipalities( int region) { string connectieString = ConfigurationSettings.AppSettings["ConnectieString"]; SqlConnection connectie = new SqlConnection(connectieString); SqlCommand commando = new SqlCommand("spRetrieveMunicipalities", connectie); SqlDataAdapter adapter = new SqlDataAdapter(commando); commando.CommandType = CommandType.StoredProcedure; SqlParameter parameterHoofdgroep = new SqlParameter("@region", SqlDbType.Int); parameterregion.Value = region; commando.Parameters.Add(parameterregion); DataTable regions= new DataTable(); adapter.Fill(regions); connectie.Close(); return regions; } Greetings, Marco :doh:
Marco van der Linden
Posts
-
Parse the selected value from ddl and fill another ddl with information + NHibernate + C# -
Parse the selected value from ddl and fill another ddl with information + NHibernate + C#Hi Thommie, I think your looking for somting like this: private void ddlRegions_SelectedIndexChanged(object sender, System.EventArgs e) { RetrieveMunicipalities( int.Parse( ddlRegions.SelectedValue ) ); } private void RetrieveMunicipalities( int region) { ddlMunicipalities.DataSource = Retrieve_Municipalities( region); ddlMunicipalities.DataBind(); } Greetins, Marco van der Linden
-
String To XMLHello Elizma, Just write the string to a file with the extention ".xml". Greetings, Marco van der Linden
-
Unable to run a report from client PC...hello Ajay Kumar, I had the same error.. try installing the Crystal Reports for .NET Framework 2.0 it works for me now http://msdn2.microsoft.com/en-us/library/ms225293(VS.80).aspx[^] Greetings, Marco van der Linden :)
-
HejHello, With the next call you go back to the previous url. Response.Redirect(Request.UrlReferrer); Greetings, Marco