Archive for

SqlHelper ASP.NET (VB)

Before set connectionString in web.config </configuration> <appSettings> <add key=”ConnectionString” value=”server=localhost;uid=sa;pwd=sa;database=DBNAME” /> </appSettings> </configuration> 1. Fill DropDownList Dim ds As DataSet = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings(“ConnectionString”), “sp_name”, “FieldName = 1”) ddl.DataSource = ds ddl.DataBind() ddl.Items.Insert(0, “-please select one-“) Fungsi dari ddlGolongan_Pemilik.Items.Insert(0, “”) untuk memberikan nilai default. 2. Bind DataGrid DataGrid4.DataSource = SqlHelper.ExecuteReader(ConfigurationSettings.AppSettings(“ConnectionString”) , CommandType.Text, strSql); DataGrid4.DataBind();