Jintal Patel

hiii in sql server we can't identify Case Sensitive..so if u want then store encripted password in database.means use the encription/decrition method for password .using that u can able to match exact value.

Jintal Patel

Good Jock...

Jintal Patel

hii show me your code where u assign dataset to datalist your connection And filling dataset from storeprocedure is right..

Jintal Patel

hi just show your both urla first in wchich u r trying to change the value and the original url

Jintal Patel

Page.ClientScript.RegisterStartupScript(Page.GetType(), "@msg", "alert('Message that u want to display...');", true);

Jintal Patel

try like this int value=(int)Application["Discount"].ToString(); OR int value=Convert.Toint32(Application["Discount"].ToString());

Jintal Patel

hi visit this link http://www.modport.co.uk/index.php?showtopic=2045

Jintal Patel

hii i have change my url name according to my requirment using global file concept this is my function void Application_BeginRequest(Object sender, EventArgs e) { String strCurrentPath; String strCustomPath; String StrReferrer; if (Request.UrlReferrer != null) StrReferrer = Request.UrlReferrer.PathAndQuery.ToString(); else StrReferrer = ""; // for SubCategory strCurrentPath = Request.Path; strCurrentPath = strCurrentPath.ToLower().Replace("/RedTag/Client/".ToLower(), ""); if (strCurrentPath.StartsWith("subcategory.aspx")) { strCurrentPath = StrReferrer; strCurrentPath = strCurrentPath.ToLower().Replace("/RedTag/Client/".ToLower(), ""); } if (strCurrentPath.StartsWith("c-")) { string id = strCurrentPath.Split('-')[1].ToString(); strCustomPath = "category.aspx?catid=" + id.ToString(); Context.RewritePath(strCustomPath); } if (strCurrentPath.StartsWith("m-")) { string id = strCurrentPath.Split('-')[1].ToString(); strCustomPath = "subcategory.aspx?MFRID=" + id.ToString(); Context.RewritePath(strCustomPath); } if (strCurrentPath.StartsWith("s-")) { string id = strCurrentPath.Split('-')[1].ToString(); strCustomPath = "SubCategory.aspx?catid=" + id.ToString(); HttpContext.Current.RewritePath(strCustomPath); // Context.RewritePath(strCustomPath); } if (strCurrentPath.StartsWith("p-")) { string id = strCurrentPath.Split('-')[1].ToString(); strCustomPath = "ItemPage.aspx?ProductID=" + id.ToString(); Context.RewritePath(strCustomPath); } } now problem is that first time when my subcategory page load that time the url is like Client/s-1001-Data.aspx but when i do paging then my page is ispostback and my url change to SubCategory.aspx?catid=1001 means which is in my Context.RewritePath ..i want the same url name should maintain through out the page...

Jintal Patel

hi i want to use text file as my data storage.i be able to insert & retrive from text file ..but how to update and delete prticulare line in text file?

Jintal Patel

welcome

Jintal Patel

hiii this will definately work just change ur str2 to belove str2 = "select * from Birthday WHERE (DATEPART('m', BDate)) = '" & Date.Today.Month & "' And (DATEPART('d', BDate)) = '" & Date.Today.Day & "'" cm = New OleDbCommand(str2, con) GridView1.DataSource = cm.ExecuteReader(CommandBehavior.CloseConnection) GridView1.DataBind()

Jintal Patel

hi how to implement paging & sorting in gridview...both r working but if my page size is 20 and records r 60 then the sorting done on 60 records insted of 20 record of current page... i have tried like this public DataSet GetDatasetForPage(DataSet dsGlobal, int pageindex, int pagesize) { string Query = "Select * From tb where Deleted!=1"; SqlConnection myConnection = dbAccess.SQLConn; dsGlobal.Tables[0]. SqlDataAdapter dapter = new SqlDataAdapter(Query,myConnection); dapter.Fill(dsGlobal, pageindex, pagesize, "tb"); return (dsGlobal); } but i don't want to execute select statement each and every time...

Jintal Patel

please send me the total code or that function so i can understand your problem perfactly...

Jintal Patel

hii sorry for let reply.. try this... str2 = " Select * from Bithdays WHERE (DATEPART(month, BirthDate)) ='" & Date.Today.Day &"' And (DATEPART(day, BirthDate) = '" & Date.Today.Month & "'"

Jintal Patel

your syntax is wrong near '" & Date.Today.Day ' for concat so correct syntax

Jintal Patel

hi try with this query.. if i m not wrong then BirthDate is your table column name .. select * from Tablename WHERE (DATEPART(month, BirthDate) = @mt) AND (DATEPART(day, BirthDate) = @dt) set value of this both variable as u want

Jintal Patel

hi i want to compare date using compare validator .and date format must be mm/dd/yyyy .how to set that??

Jintal Patel

hi in my one from i have both Iframe and Grid view.from hyperlink of gridview i have open different forms in Iframe in same Page.but problem is :- i want to disable gridview after click on perticular hyperlink.how's this possible

Jintal Patel

hi i have used From tag in Content Page ..and try to Retrive From Tag using request.From .but it gives me null ref error

Jintal Patel