Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
143703 | Apr 1,2019 03:24 PM UTC | Apr 2,2019 07:18 AM UTC | ASP.NET Web Forms | 1 |
![]() |
Tags: Grid |
<ej:Button ID="Button" runat="server" Type="Button" Text="Update Sql DataSource" Size="Large" Width="80px" OnClick="Button_Click">
</ej:Button>
<ej:Grid ID="OrdersGrid" runat="server" AllowPaging="True" >
<Columns>
<ej:Column Field="OrderID" HeaderText=" Order ID" IsPrimaryKey="True" TextAlign="Right" Width="75">
</ej:Column>
. . .
</ej:Grid>
Serverside:-
DataTable dt = new DataTable("Order");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void dataBind()
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ToString());
dt = new DataTable("Order");
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "select * from Orders";
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
if (myConnection.State == ConnectionState.Closed)
{
myConnection.Open();
}
da.Fill(dt);
OrdersGrid.DataSource = Syncfusion.JavaScript.Utils.DataTableToJson(dt);
OrdersGrid.DataBind();
myConnection.Close();
}
protected void Button_Click(object sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
{
dataBind();
} |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.