User-444409258 posted
default.aspx
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" />
<h3>
Home Page text Change</h3>
<table>
<tr>
<td>
Title Name: *
</td>
<td>
<asp:TextBox ID="home_Title" runat="server" CssClass="wm" />
</td>
</tr>
<tr>
<td colspan="4" style="text-align: left;">
<h3>
:: Description ::</h3>
</td>
</tr>
<tr>
<td valign="top">
</td>
<td colspan="3">
<asp:TextBox ID="Home_name" runat="server" CssClass="wm" TextMode="MultiLine" Height="302px"
Width="590px" />-
</td>
</tr>
<tr>
<td colspan="2" class="style1">
<asp:Button ID="Add_Home" CssClass="prdbtn" runat="server" Text="Submit" OnClientClick="return checkEmpty();"
OnClick="Add_Home_Click1" />
</td>
</tr>
</table>
</asp:Content>
back end code
on default.aspx.cs page
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Security;
using System.Security.Permissions;
using System.IO;
using System.Text;
public partial class Adm_product_add_Home : System.Web.UI.Page
{
DBcommand DBAcquire = new DBcommand();
protected void Page_Load(object sender, EventArgs e)
{
Label prd_info = new Label();
if (!Page.IsPostBack)
{
string type = Request.QueryString["type"].ToString();
if (type == "add")
{
}
else
{
DBAcquire.open_conn();
int id = DBAcquire.GetID("select catid from Home where Cat='" + Request.QueryString["catid"] + "'");
DBAcquire.new_comm("select Cat, description from Home where catid=" + id + "");
DBAcquire.DBReader();
if (DBAcquire.readDB.Read())
{
home_Title.Text = DBAcquire.readDB.GetValue(0).ToString();
Home_name.Text = DBAcquire.readDB.GetValue(1).ToString();
// prd_info.Text = DBAcquire.readDB.GetValue(1).ToString();
}
DBAcquire.readDB.Close();
DBAcquire.comm.Cancel();
DBAcquire.close_conn();
// Home_name.Content = prd_info.Text;
}
}
}
protected void Add_Home_Click1(object sender, EventArgs e)
{
String type;
type = Request.QueryString["type"].ToString();
if (type == "add")
{
DBAcquire.open_conn();
string state;
int pass = 0;
state = "select max(pos) from Home";
DBAcquire.new_comm(state);
DBAcquire.DBReader();
while (DBAcquire.readDB.Read())
{
if (!DBAcquire.readDB.IsDBNull(0))
{
pass = Convert.ToInt32(DBAcquire.readDB.GetValue(0));
}
}
pass++;
DBAcquire.readDB.Close();
string str;
str = string.Format("insert into Home (Cat, description, pos) values ('" + home_Title.Text + "','" + Home_name.Text + "'," + pass + ")");
DBAcquire.new_comm(str);
DBAcquire.comm.ExecuteNonQuery();
DBAcquire.close_dbcommands();
DBAcquire.close_conn();
}
else
{
DBAcquire.open_conn();
int id = DBAcquire.GetID("select Catid from Home where Cat='" + Request.QueryString["Catid"] + "'");
string qry;
qry = string.Format("update Home set Cat ='" + home_Title.Text + "', description='" + Home_name.Text + "' where Catid=" + id + "");
DBAcquire.new_comm(qry);
Response.Write(qry);
DBAcquire.executecommand();
DBAcquire.comm.Cancel();
DBAcquire.close_conn();
}
Response.Redirect("default.aspx");
}
}
my class code is here DBCommand.cs page code
using System;
using System.Collections.Generic;
using System.Web;
using System.Data.Sql;
using System.Configuration;
using System.Data.SqlClient;
using System.Collections;
/// <summary>
/// Summary description for DBcommand
/// </summary>
public class DBcommand
{
#region Global Variables
SqlConnection conn;
public SqlCommand comm, comm1;
public SqlDataReader readDB, readDB1;
#endregion
public DBcommand()
{
//
// TODO: Add constructor logic here
//
conn = new SqlConnection();
}
public void open_conn()
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.ConnectionString = @"Data Source=ZUBAIRKHALIL-PC\SQLEXPRESS;Initial Catalog=germony;Integrated Security=True;MultipleActiveResultSets=True";
conn.Open();
}
}
public void close_conn()
{
conn.Close();
conn.Dispose();
}
public void new_comm(String query)
{
comm = new SqlCommand(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
}
public void new_comm1(String query)
{
comm1 = new SqlCommand(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
if (readDB1 != null)
{
readDB1.Close();
}
}
public void DBReader()
{
if (readDB != null)
{
readDB.Close();
}
readDB = comm.ExecuteReader();
}
public void DBReader1()
{
readDB1 = comm1.ExecuteReader();
}
public void close_dbcommands()
{
readDB.Close();
comm.Cancel();
}
public void executecommand()
{
comm.ExecuteNonQuery();
}
public void executefast()
{
comm.ExecuteScalar();
}
public System.Data.DataView get_dataset(String query)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
data.Fill(ds, "Country_name");
return ds.Tables[0].DefaultView;
}
public System.Data.DataTable GetData(string qry)
{
if (conn.State != System.Data.ConnectionState.Open)
open_conn();
System.Data.DataTable dt = new System.Data.DataTable();
SqlDataAdapter cmd = new SqlDataAdapter(qry.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
cmd.Fill(dt);
return dt;
}
public string Encoder(String pass)
{
try
{
byte[] encData_byte = new byte[pass.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(pass);
string encodedData = Convert.ToBase64String(encData_byte);
return encodedData;
}
catch (Exception ex)
{
throw new Exception("Error in base64Encode" + ex.Message);
}
}
public string decoder(String pass)
{
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder utf8Decode = encoder.GetDecoder();
byte[] todecode_byte = Convert.FromBase64String(pass);
int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);
char[] decoded_char = new char[charCount];
utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
string result = new String(decoded_char);
return result;
}
public string folder_name_encode(String url)
{
url = url.ToString().Replace(" ", "_").Replace("/", "[0]").Replace("<", "[1]").Replace(">", "[2]").Replace(":", "[3]").Replace("*", "[4]").Replace("?", "[5]").Replace("|", "[6]").Replace("\"", "").Replace("\\\\", "[8]");
return url;
}
public string url_split(String url)
{
String[] uri = url.ToLower().Replace("code", "#").Split('#');
return uri[0];
}
public Int32 GetID(string qry)
{
Int32 id = 0;
SqlDataAdapter da = new SqlDataAdapter(qry, conn);
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
id = (dt.Rows.Count > 0) ? Convert.ToInt32(dt.Rows[0][0]) : 0;
return id;
}
public void executenonquery(string query)
{
if (conn.State != System.Data.ConnectionState.Open)
open_conn();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
}
check this three file i can insert when i click on ADD button then go to the default.aspx page , i can send query string to this page
like this
protected void add_Home_Click(object sender, EventArgs e)
{
string strqry;
strqry = "select catid from Home where cat='" + Home.SelectedItem + "'";
try
{
DBAcquire.open_conn();
DBAcquire.new_comm(strqry);
DBAcquire.DBReader();
int add = 0;
while (DBAcquire.readDB.Read())
{
add = Convert.ToInt32(DBAcquire.readDB.GetValue(0).ToString());
}
Response.Redirect("default.aspx?type=add&catid=" + add + "");
DBAcquire.close_dbcommands();
DBAcquire.close_conn();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
database table code here
CREATE TABLE [dbo].[Home](
[Catid] [int] IDENTITY(1,1) NOT NULL,
[Cat] [nvarchar](4000) NULL,
[Pos] [int] NULL,
[Description] [nvarchar](4000) NULL,
CONSTRAINT [PK_Home] PRIMARY KEY CLUSTERED
(
[Catid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
