http://www.codeproject.com/script/comments/forums.asp?msg=1985635&forumid=12076&mode=all&userid=3585246#xx1985635xx note: I have used free SQLHelper Class to connect with database.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
dt_News = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, "select newsletter_type_id,newsletter_type_name from newsletter_type_master"); chkNews.DataTextField = "newsletter_type_name"; chkNews.DataValueField = "newsletter_type_id"; chkNews.DataSource = dt_News; chkNews.DataBind(); /////////Get and display checked newsletter dt_NewsClicked = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, "select newsletter_type_id from user_newsletter_type where user_id='"+userId+"'"); int w = dt_NewsClicked.Rows.Count; int[] newsChecked = new int[20]; for (int i = 0; i < dt_NewsClicked.Rows.Count;i++) { newsChecked[i] = Convert.ToInt32(dt_NewsClicked.Rows[i]["newsletter_type_id"].ToString()); } for (int a = 0; a < w ; a++) { chkNews.Items[newsChecked[a]-1].Selected = true; } ------------------------------------------------------------------------ note : I use free SQLHelper Class to connect with database. chkNews is my Checkbox group.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
I don't know why you want to use webservice. But easy way is to use Datatable to store Temporarily data. This can work if both databases are on same domain. I use free sqlhepler class to connect with database. ------------------------------------------------------------------------------ string sql="Select user_id,name from user_master"; DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionStringfordatabase1, CommandType.Text, sql); foreach (DataRow dr in dt.Rows) { sql = "Inser into user_master (user_id,name) values('" + dr["user_id"] + "','" + dr["name"] + "')"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringfordatabase2, CommandType.Text, sql); } ------------------------------------------------------------------------------
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
The only thing you can do is clear browser's history and delete offline content.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
When I use this I get a error about converting data from char to integer probably because the data type in database is a Integer. query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'" -------------------------------------------------------------------- Then you had to just reomve quotes. Like : query = "UPDATE [Temp] SET [value] = " + txt + " WHERE [name] = 'temprature'" --------------------------------------------------------------------
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Have you tried this : ---------------------------------------------- query = "UPDATE [Temp] SET [value] = '" + txt + "' WHERE [name] = 'temprature'"
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
User System.Threading.Thread class. for example, If u want to dalay for 5 seconds at server side then, System.Threading.Thread.Sleep(5000); where argument is in miliseconds. Cheers.:-O
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
I hope you have given datasource to dropdown in ---------------------------------- protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { dropdown.datasource=dc; dropdown.databind; dropdown.datatextfield=dtf; dropdown.datavaluefield=dvf; } }
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Try this - This code is in c# and you need to use your way to get datatable instead over sqlhepler. ----------------------- string sql = 'Select * from user_MASTER'; DataTable dt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, sql); Response.AddHeader("Content-Disposition", "inline;filename=Final.xls"); int i; for (int icol = 0; icol < dt.Columns.Count; icol++) { Response.Write(dt.Columns[icol].ToString() + "\t"); } Response.Write("\n"); foreach (DataRow dr in dt.Rows) { for (i = 0; i < dt.Columns.Count; i++) { Response.Write(dr[i].ToString() + "\t"); } Response.Write("\r"); } Response.End();
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
It's easy. Because you have write: ViewState["SortOrder"] = ""; in Page load So everytime it will make if(ViewState["SortOrder"].ToString() == "") true I think you may write this in page load : if(ViewState["SortOrder"]==null) { ViewState["SortOrder"] = ""; } Hope it works.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Write this code in ItemDataBound Event ----------------------------- LinkButton lbd = (LinkButton)e.Item.FindControl("lbDLI"); if (e.Item.FindControl("lbDLI") != null) { if (DataBinder.Eval(e.Item.DataItem, "LIVE") != null) // Here LIVE is column name in database { int i = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "LIVE")); if (i == 0) { lbd.Text = "Idle"; } else { lbd.Font.Bold = true; lbd.ForeColor = Color.Green; lbd.Text = "Live"; } } }
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
protected void Page_Load(object sender, EventArgs e) { DataTable dt = commonfunctions.fillCategory(1); } public static DataTable fillCategory(int catID) { DataTable dt = new DataTable(); dt.Columns.Add("CATEGORY_ID", typeof(int)); dt.Columns.Add("CATEGORY_NAME", typeof(string)); dt.Columns.Add("LEVEL", typeof(int)); dt.Columns.Add("PARENT_CATEGORY", typeof(int)); dt = commonfunctions.fillCat(catID, dt, 0); return dt; } public static DataTable fillCat(int catID, DataTable dt, int i) { DataTable currdt = new DataTable(); DataTable cdt = new DataTable(); DataTable ccdt = new DataTable(); string query; query = "SELECT CATEGORY_ID, CATEGORY_NAME, PARENT_CAT_ID FROM CATEGORY_MASTER WHERE CATEGORY_ID = " + catID; currdt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, query); string name = currdt.Rows[0][1].ToString(); for (int cnt = 0; cnt < i; cnt++) { name = "-" + name; } dt.Rows.Add(currdt.Rows[0][0], name, i, currdt.Rows[0][2]); query = "SELECT CATEGORY_ID, CATEGORY_NAME FROM CATEGORY_MASTER WHERE PARENT_CAT_ID = " + catID ; cdt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, query); foreach (DataRow drc in cdt.Rows) { query = "SELECT COUNT(*) FROM CATEGORY_MASTER WHERE PARENT_CAT_ID = " + catID ; ccdt = SqlHelper.ExecuteDatatable(SqlHelper.ConnectionString, CommandType.Text, query); if (Convert.ToInt32(ccdt.Rows[0][0].ToString()) > 0) { i++; dt = fillCat(Convert.ToInt32(drc[0].ToString()), dt, i); i--; } else { name = drc[1].ToString(); i--; for (int cnt = 0; cnt < i; cnt++) { name = "-" + name; } dt.Rows.Add(drc[0], name, i, catID); } } i--; return dt; } --------------------------------------- Here I have just one table. Category_Master And Column are : Category_id Category_Name Parent_Category_ID
But When i put break point and check the value of strQuery, it is showing "textboxvalue" instead of characters typed in the textbox. Because you are the biggest fool in this community. Try this -- function limitText(){ var textboxvalue = document.getElementById("limitedtext").value; if(textboxvalue.length == 10) { alert(textboxvalue); var link = "popup.aspx?value=" + textboxvalue; window.open(link,"","resizable=1,width=600,height=200") } }
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Server Side - protected void Page_Load(object sender, EventArgs e) { TextBox1.Attributes.Add("onkeydown", "return checkvalid()");// Call Javascrip } Client Side - function checkvalid() { var sTxt = event.srcElement.value; var i = event.keyCode; //alert(i); if((i<47 || i>58) && i!=8 && i!=16 && i!=20) { alert("Not allowed"); event.srcElement.value=""; return false; } } But remind when you are adding attributes to this control requirefield validator will not work.
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
You have to give SortExpression for each template. SortExpression="USER_MASTER.USER_LEVEL_ID desc" And on event sorting you have to use it in sorting event like : e.SortExpression
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
private DataSet GetExcelData(string fileName) { try { string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=0;\""; OleDbConnection conn = new OleDbConnection(sConnectionString); conn.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = conn; command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM [Sheet1$]"; OleDbDataAdapter da = new OleDbDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds, "Final"); conn.Close(); return ds; } catch (Exception ex) { lblError.Text = ex.Message; return null; } } protected void Upload_Excel(object sender, EventArgs e) { if (UPExcel.PostedFile != null) { try { string fileName = UPExcel.PostedFile.FileName.Substring(UPExcel.PostedFile.FileName.LastIndexOf(@"\") + 1); fileName = Server.MapPath(".") + @"\UploadedFiles\" + fileName; UPExcel.PostedFile.SaveAs(fileName); DataSet ds = GetExcelData(fileName); if (ds.Tables["Final"] != null && ds.Tables["Final"].Rows.Count > 0) { foreach (DataRow dr in ds.Tables["Final"].Rows) { string sql = ""; if (dr["user_id"] != null && dr["user_id"] != System.DBNull.Value && dr["user_id"].ToString().Trim() != string.Empty) { sql = "INSERT INTO USER_MASTER (USER_ID,PASSWORD,FNAME,LNAME,ADDRESS1,ADDRESS2,CITY_ID,STATE_ID,COUNTRY_ID,EMAIL,EMAIL_VERIFIED) values(" + dr["user_id"] + ",'password','" + dr["user_firstname"] + "','" + dr["user_lastname"] + "','" + dr["user_address_1"] + "','" + dr["user_address_2"] + "'," + dr["user_region_id"] + "," + dr["user_state_id"] + "," + dr["user_cid"] + ",'" + dr["user_email"] + "',1)"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql); } } } } catch (Exception ex) { lblError.Text = ex.Message; } } }
Regards, Mayank Parmar Senior Sof
I don't know wheather you can edit Web.config or not. But I have done this thing using xml file. I have add key connectstring in xml file. And I can chamge it runtime. Hope you like using xml file:|
Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India
Hi friends, I am developing Shopping cart in ASP.NET. Whenever I am entering username and password in ASP.NET Login Control, the problem with focus is occured. I want to Login the user without requiring user to click LOGIN button....means whenever the user enters the username and password, and If he do enter, he should be Login. Chintan Mistry