db d = new db();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// ddlDataBase.DataSource = d.getDataTable("select * from sysdatabases");
// ddlDataBase.DataTextField = "name";
// ddlDataBase.DataValueField = "name";
// ddlDataBase.DataBind();
ddlList.DataSource = d.getDataTable("select * from sysobjects where xtype='u'");
ddlList.DataTextField = "name";
ddlList.DataValueField = "name";
ddlList.DataBind();
}
}
protected void ddlDataBase_SelectedIndexChanged(object sender, EventArgs e)
{
ddlList.DataSource = d.getDataTable("select * from sysobjects where xtype='u'");
ddlList.DataTextField = "name";
ddlList.DataValueField = "name";
ddlList.DataBind();
}
protected void cblColumns_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddlList_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select * from " +ddlList.SelectedValue;
DataTable dt = d.getDataTable(sql);
for (int i = 0; i < dt.Columns.Count; i++)
{
ListItem li = new ListItem(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
li.Selected = true;
cblColumns.Items.Add(li);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder sb=new StringBuilder("insert into "+ddlList.SelectedValue+"(");
int i=0,j=0;
foreach(ListItem li in this.cblColumns.Items)
{
if( li.Selected ){
i = i + 1;
if (i != 1)
sb.Append(",");
sb.Append(li.Text);
}
}
sb.Append(")");
sb.Append(" values(");
foreach( ListItem li in this.cblColumns.Items)
{
if (li.Selected)
{
j = j + 1;
if (j!=1)
sb.Append(",");
sb.Append("@" + li.Text);
}
}
sb.Append(")");
this.TextBox1.Text = sb.ToString();
}
protected void Button2_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder("update "+ddlList.SelectedValue+" set ");
int i = 0, j = 0;
foreach(ListItem li in this.cblColumns.Items)
{
if( li.Selected){
i = i + 1;
if (i!=1)
sb.Append(",");
for(int k=0;k<2;k++)
{
if (k == 0)
sb.Append(li.Text + "=");
else
sb.Append("@" + li.Text);
}
}
}
TextBox1.Text = sb.ToString();
}