Comments by Surendra0x2 (Top 166 by date)

sir suppose i want to match mobile numbers containing patter aabb-2233 means all possible combinations 1122 or 3344 or 5566

Sir it is for c#?when i applied in c# its not returning any matched results..

like Mobile Number Starts With 9839 and Rest 6 Digits are AXXXXY means 9839255556 here 5 repeating 4 times I want to build a regular expression it and search in database matching regular expression like this.

sir yes it is vulnerable to sql injection but i ll do this using Stored procedure but i want to resolve my current issue i added HttpContext.Current.ApplicationInstance.CompleteRequest after response.redirect but still unable to redirect :(

when i placed my code inside try catch block i got error Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.
thats y i added Response.Redirect(url, false); false but it did not work.

As you posted your code there is only one Column. then why r u Indexing 1 and 2 just simply
write
protected void GrdView_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
grdListings.Columns[0].ItemStyle.Width = 50;
}
}

May be your Giving Wrong Indexing to column.
protected void GrdView_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{
grdListings.Columns[1].ItemStyle.Width = 50;
grdListings.Columns[2].ItemStyle.Width = 150;
}
}

This code is not wroking?

Instead of DataControlRowTYpe.Header use if (e.Row.RowType == DataControlRowType.DataRow)
{

Sir,Yes CommonMethod is a Class and Method inside class is-
public static void ExecuteNonQueryWithTrans(string Sql, SqlConnection sqlconn, SqlTransaction Sqltrans)
{

try
{

SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlconn;
sqlCmd.Transaction = Sqltrans;
sqlCmd.CommandText = Sql;
sqlCmd.CommandTimeout = 0;
sqlCmd.ExecuteNonQuery();

}
catch (SqlException ex)
{
throw new ApplicationException("Data error (Non Query).");
}

}

How?Please Tell me Sir

Thanks :)

Thanks :)

Thanks

Thanks Buddy You Saved My ass :)

function addyear()
{

var yr=parseInt(document.getElementById("<%=TextBox1.ClientID %>").value);

document.getElementById("<%=TextBox2.ClientID %>").value=yr+1;



}

Check Regex like [a-zA-Z0-9] with Custom Validator

Sir,Its Windows Application not Web.

+5

Place Dropdownlists Inside Update panel :)

:D

Thanks Buddy :)

According to my requirement i can't use two update panel bro i can't make u understand :(

i did not get what u described suppose we have both button inside update panel and i don't want updateprogress image to appear on delete button then?
like

<asp:updatepanel id="UpdatePanel1" runat="server">
<contenttemplate>
<asp:button id="btnSearch" runat="server" text="Update" onclick="btnSearch_Click" />
<asp:button id="btn" runat="server" text="Delete" onclick="btn_Click" />

What the?Don't you know when we refresh page then also postback occurs :D

i looked for sourcecode of codeproject but did not get it,its only using tooltip jquery and data is not inside hidden div.but still on tooltip it fetches the data.

http://www.codeproject.com/Questions/550722/Howplustoplusdisableplusthepluscolumnplusheaderplu

check this link

My Pleasure :)
Happy Coding :)

You Can Download Dew Player check this site-
www.alsacreations.fr/dewplayer-en.html

I was about to Edit solution thanks for Editing Amit :)

I'm Glad it helped you :)
Happy Coding :)

html image?what u saying dude ?ur question is not clear what ur trying to ask.

like-
TextBox1.ForeColor = System.Drawing.Color.Green;
or backcolor
like
TextBox1.BackColor = System.Drawing.Color.Yellow;
use according to ur need.
if(some condition)
{
TextBox1.ForeColor = System.Drawing.Color.Green;
}

Textbox Text color?
u mean text color?

Nitish if u found my answer helpful then accept it :) thanks

sql = "Update Tb_SCH_Faculty_Details set [Course_Duration,Allocated_Hours] = '" + textbox2.Text + "','" + textbox3 .Text + "' where Cmn_Minor_Code = '" + txt_coursecode.Text + "'";

You Used Square Bracket here ?
why
if u want to update Multiple Columns then
simply

Update Tb_SCH_Faculty_Details set Course_Duration='" + textbox2.Text + "',Allocated_Hours='" + textbox3 .Text + "' where Cmn_Minor_Code = '" + txt_coursecode.Text + "'";

Use have a question or comments widget to comment :| u posted comment in solution .

look at the coding i used dataridview which is windows tool

i got how i can handle button click event thanks sir...
but how to apply icon and text both in the listbox ...:(

Thanks a ton sir You're genius :)
one more thing plz help me in my usercontrol there is a button how to handle that button click event?

Do like this-Bind data to Datagridview on formload
public void FillGrid()
{


using (SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=windowform;integrated security=true"))
{
SqlDataAdapter da = new SqlDataAdapter("select * from reg", sqlconn);
try
{
sqlconn.Open();

DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.AutoGenerateColumns = false;

dataGridView1.DataSource = ds.Tables[0];




}
catch (Exception ex)
{

MessageBox.Show(ex.ToString());


}
finally
{


if (sqlconn.State == ConnectionState.Open)
{

sqlconn.Close();
}

}
}

}

Whats the Use of dataGridView1.DataSource = tasksBindingSource;
instead of Make FillDatagrid(); Method on Form Load

then Call it Anywhere to see Updated Data in Datagridview

Can you tell me show to load a User control on listbox selecteditem?

+5 Dude :)

Sir,just i want to know can we generate these types of ids..
i did like but thisis not wrking-
create table autonumberid(id int identity,categoryid as('000'+convert(varchar,id)),productname varchar(20))

Thanks Sir,and can u clear my doubt what about mp3 files it would be good if i store mp3 using varbinary(max) format or just store song'name and retrieve.
and for image what if image is between 1 MB to 5MB then it would be good to store as image datatype and retrieve?

use this to save song to database and play

refer this Link i added source code-
http://www.mediafire.com/file/cc43uccvd274epp/Save_Binary_image_and_Mp3_and_Show_image_and_Play_Song_inside_gridview.rar

Thanks a ton Marcus u solved my problem :)

use sqlcommand.executenonquery(); for DML command like insert update delete

u using accordion control on child page?

Did you attach Script manager?

sir,still it will return all rows not the desired by the user above solution is gr8 :)

+5 :)

It will return all rows.

May b type casting issue or ur not filing fload value in the textbox.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=149
http://www.dotnetfunda.com/articles/article1001-ajax-calendarextender.aspx

Hi,

I suggest you do that in OnClientDateSelectionChanged event. And you could use the js like below:

function checkDate(sender, args) {
if ($find("CalendarExtender1")._selectedDate == null || sender._selectedDate < $find("CalendarExtender1")._selectedDate) {
alert("Please select again!");
sender._selectedDate = new Date();
// set the date back to the current date
sender._textbox.set_Value(sender._selectedDate.format(sender._format))
}
}

use this tag to play video file in window media player..take one label control then. follow this(Label1.Text='object code in single line without line break')
cs page-
Label1.Text='<object id='mediaPlayer' width='320' height='285'>
classid='CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95'
codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'
standby='Loading Microsoft Windows Media Player components...' type='application/x-oleobject'>
<param name='fileName' value='video url' />
<param name='animationatStart' value='true' />
<param name='transparentatStart' value='true' />
<param name='autoStart' value='true' />
<param name='showControls' value='true' />
<param name='loop' value='false' />
</object>'

and paste one video in ur solution explorer.
then play if this wroks then u can upload and save video url to database then u can pass url to window media player embed code.
let me know if this wrks.

refer this video too-
http://www.youtube.com/watch?v=FQxzGuPzs1U

refer this link-
http://irfanyar.wordpress.com/2010/10/19/disable-weekends-for-ajaxtoolkit-calendar-extender/
and

http://net-ajax.itags.org/q_dotnet-ajax_18772.html

You Posted This Question Twice :|

My pleasure bro :)

Ye to mai bhi janta hoon rohit bhai :P

if i have to pay $60 then why would i ask this question sir ;)
i also know pay and get rule but i was willing to know is there any software like httrack which can copy entire website ;)

try to deactivate your Antivirus then send mail.

Want to copy website template like themeforest templates

Gr8 :)

i did this as he suggested
http://blog.dreamlabsolutions.com/post/2009/02/24/jQuery-document-ready-and-ASP-NET-Ajax-asynchronous-postback.aspx
but still its not working :(

i'm creating forgot password and on Button click i want to send the password to the user via mail so Sir Button click is main thing here.

My Textbox and Button is inside update panel when i click on Button the toggeled Div Disappears this which i want to appear after partial postback.

I tried Both Sir But Sorry to say Both tricks not working :|

Sir,It's not working On first time page load it is showing toogle div but on Button click it is hiding means on postback and afterpostback when i'm hovering on link it is showing and hiding div.

Where to add this in script?can u plz help?

When i pasted this in header then it is showing error expected expression
sir can u check it ?

;)

window.open('Newwindow.aspx?value=' + value,'_self',true);

Add this

:)

You're Posting Your Question in Wrong section Always use Post a Question widget :)

Exactly :)

We don't Need UserName and Password For Windows Authentication

Try Above Solution---

:)

Accept the solution bro if this Helped You :)
and happy coding :)

Exactly :)

Yes if on Server then You Have to Change Folder permission :)

use this link-
http://www.activeservers.com/Set-Perms-Cuteftp.aspx

In My Case i'm using Godaddy Hosting here

select the Folder and Click on Permissions then i can change read/write permission
but in ur case i dnt know how to do this coz may be ur hosting server would be different.

gr8 Solution Rohit :)

My Pleasure Dude if u found this Link helpful then Accept as solution :)

Gr8 Solution Mam :)

Try My Above Solution This is Working i tested :)

What Means Automatically?Magically :P
or on Button_Click

Always Use Have a Question or Comment Widget to Post Your Comment in Reply.

Check this Link-
http://www.codeproject.com/Answers/501141/videoplusUploadplusandplusviewplusinplusasp-netplu#answer2

Post your full code so that otherone can understand your problem and can give answer.

yes because value is integer so we need typecasting

Seems Like Weird thing u asked dude :|

slc.Parameters["@Cust_Name"].Value = cmbCust_Name.SelectedValue.Text;

try this

refer this Link
may be this can sortout ur problem
http://social.msdn.microsoft.com/Forums/en/wpf/thread/491bd566-82e3-4f01-88a0-681f56358694

My Pleasure :)

Buddy But there is one problem arised when i'm clicking on any edit Button then it is only showing first record in pop-up it is only showing first row's Record in each row pop-up :(

Ok :)

Mam My Label is Inside Update Panel.
and i'm Opening the Content which i palced Inside Update panel in Fancybox so i dnt wanna refresh the page thats y i'm using update panel.

Thank You SO Much Buddy U soved My Problem yaar i Removed Bind() Method From itemcommand
and did
Label lbl = (Label)e.Item.FindControl("Label1");
lbl.Text = "Updated";
then it worked but when i'm just writing Label1.Text="Updated" then was not showing

anyways thanks i manipulated the code and it worked thanks

LOL :D

oops Buddy I'm facing one problem can u help me out
http://www.codeproject.com/Questions/503826/LabelplusTextplusNotplusshowingplusafterplusUpdati

check this n help dude if u can

Yes i tested it is showing before updation means if i set Text="Something" then it is showing But when i'm clicking on Update Button then it is not showing

Exactly Sir :)

Gr8 Answer Sir :)

without where Clause :O

Instead of this Do this-
http://alanfeekery.com/2011/03/28/changing-the-asp-net-target-framework-in-visual-web/

Oh Sorry Sir

Here is working Demo-
http://surendrakumarverma.com/Video.aspx

Ajax Asycfileupload control is an alternate solution for this problem :)

it is called indian coding Jugaad :P Mudassar Sir did this :D

it is possible gayatri mam
check this link ;)
http://www.aspsnippets.com/Articles/Using-FileUpload-Control-inside-ASP.Net-AJAX-UpdatePanel-Control.aspx

OOps :| thanks by d way :(

it worked sir when i changed to british language thanks a ton sir for giving me ur time.
n sorry for bothering you :(

british language having format dmy so should i change to british?
SELECT * FROM sys.syslanguages
set language british
can i use this?

sir what about ur regional language?as i'm also in india i want to set regional language to india.

sir can you write the query u used to execute to get the desired output plz post the query.

i changed 02/06/2012 now it is showing first two rows but sir
SELECT * FROM emp_reg WHERE joining_date between Convert(datetime ,'01/01/2012') AND Convert(datetime ,'02/06/2012');
here 01 and 02 are dates so it is giving output according to date and 01 and 06 are months so accroding to me it should return rows from 01 to 06 months. but it is not considering months :| and when converting above varchar datatype to datetime the date will be in format yyyyy/mm/dd..

Sir as u updated ur query it is returning rows accroding to dd(date) it is not considering mm(month)
in ur query
SELECT *
FROM emp_reg
WHERE joining_date between Convert(datetime ,'01/01/2012') AND Convert(datetime ,'06/02/2012');

01 and 02 showing months so the above query should return only first 2 rows of table mentioned above but it is returing all rows as 01 and 06 dates containing all rows.

sorry for bothering u sir.

i think sqlserver2005 does not support Date datatype....?

create table emp_reg(emp_id int identity,emp_name varchar(20), emp_city varchar(20),joining_date date)
when i'm executing this query i'm getting error
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #4: Cannot find data type Date.
i'm using sql server 2005
datetime datatype working fine. but date giving this error.

sir if the datatype of joining date is datetime then ?
my sql query is to create table create table emp_reg(emp_id int identity,emp_name varchar(20), emp_city varchar(20),joining_date datetime)

calender control selected date gives format like dd/mm/yyyy n this format is saving in databse like
1 surendra jabalpur 2012-01-06 00:00:00.000

then how can we write the same query for this ?

what is to_date in the above query sir?

i'm using calender control for textbox and it returns date in 01/12/2012 format
there are two textbox for searching record with given dates..
like from date to todate and in both textbox i'm using calender control in dateformat 01/12/2012 so how can i use this between clause sql query to search from my table?

here is the registration form sir plz can you check the problem.
http://surendrakumarverma.com/Signup.aspx

Thanks Sir...
But sir there is an another problem related to this on key up event when i'm deleting textbox text n making textbox blank then it shows Available

on Keyup if textbox is blank then it is showing available

string name = TextBox2.Text;
string to = "surendra.verma1989@gmail.com";
string from = TextBox3.Text;
string subject = TextBox4.Text;
string msg1 = TextBox1.Text;
SmtpClient client = new SmtpClient();
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.EnableSsl = true;
client.Host = "smtp.gmail.com";
client.Port = 465;

// setup Smtp authentication
System.Net.NetworkCredential credentials =
new System.Net.NetworkCredential("musicmaniauser@gmail.com", "xyz");
client.UseDefaultCredentials = false;
client.Credentials = credentials;

MailMessage msg = new MailMessage();
msg.From = new MailAddress("musicmaniauser@gmail.com");
msg.To.Add(new MailAddress("surendra.verma1989@gmail.com"));

msg.Subject = TextBox4.Text; ;
msg.IsBodyHtml = true;
msg.Body = string.Format("Name:" + name + "<br>Sender Email:" + from + "<br>Subject:" + subject + "<br>Message:" + msg1 + "");

try
{
client.Send(msg);
lbl.ForeColor = Color.Green;
lbl.Text = "Your message has been successfully sent.";
}
catch (Exception ex)
{
lbl.ForeColor = Color.Red;
lbl.Text = "Error occured while sending your message." + ex.Message;
}

The server response was: 5.5.1 Authentication Required. " getting this error on godaddy hosting

Sir i know how to send email using gmail in asp.net its working fine on localhost but its not working on godaddy hosting :(

Thanks sir i Found the Solution
here it is
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Label lbl = (Label)e.Item.FindControl("Label3");
if (Convert.ToInt32(lbl.Text) > 2)
{
lbl.BackColor = System.Drawing.Color.Green;
}
}
}

thanks for giving me ur precious tym :) god bless you :)

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Label lbl = (Label)e.Item.FindControl("Label3");
if (Convert.ToInt32(lbl.Text) > 2)
{
lbl.BackColor = System.Drawing.Color.Green;
}
}
}

Thanks a Ton Buddy Your Gr8 Sir :) You solved My problem :)

here is my code and its working now :)

Thanks sir

public void changecolor()
{



string SqlConnect = System.Configuration.ConfigurationManager.ConnectionStrings["Connect"].ConnectionString;
SqlConnection Sqlconn = new SqlConnection(SqlConnect);
SqlCommand sqlcomm = new SqlCommand("select * from Addstock", Sqlconn);
Sqlconn.Open();
SqlDataReader dr = sqlcomm.ExecuteReader();
if (dr.Read())
{


foreach (RepeaterItem item2 in Repeater1.Items)
{

if (Convert.ToInt32(dr["Quantity"].ToString()) > 2)
{
Label lbl = (Label)item2.FindControl("Label3");
lbl.Attributes.Add("style", "background-color:Green;");

}
else if (Convert.ToInt32(dr["Quantity"].ToString()) < 2)
{

Label lbl = (Label)item2.FindControl("Label3");
lbl.Attributes.Add("style", "background-color:Red;");

}


}
Repeater1.DataSource = dr;
Repeater1.DataBind();

dr.Close();
Sqlconn.Close();

}

My Cs page

and

My aspx code is
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table class="rounded-corners">
<tr style="background-color:#F58810" class="rounded-corners">
<th>Select</th>
<th>Stock ID</th>
<th>Category</th>
<th>Product Name</th>
<th>Price(in Rs)</th>
<th>Quantity</th>
<th>Warranty</th>
<th>Purchasing Date</th>
<th>Edit</th>

</tr>




</HeaderTemplate>

<itemtemplate>

<tr>
<td>
<asp:CheckBox ID="CheckBox1" runat="server" /></td>
<td>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("id") %>'></td>
<td><%#Eval("CatName") %></td>
<td><%#Eval("ProductName") %></td>
<td><%#Eval("ProductPrice") %></td>
<td >
<asp:Label ID="Label3" runat="server" Text='<%#Eval("Quantity") %>'></td>
<td><%#Eval("warranty") %></td>
<td><%#Eval("PurchasingDate") %></td>
<td><img src="Icons/1349549314_edit.ico" alt="" /></td>
</tr>

<%-- <itemtemplate>

--%>
<footertemplate>
</table>



}


but still not working sir can u plz check my code that what mistake i'm doing.

on ctrl+R i want to clear Label's value

i want on Button Click, Label2 will appear and after when i refresh the page i want to clear the label's value

label2 sir you can find on above code

Sir i want to clear label when page is refreshed by user
first time when i'll click on button then it will show label but when at the same time if i refresh the page then i want to clear the label's value

But if i set this then when i'll click on button then label2 will not show message
Label2.text="Stock Detail(s) Deleted";

public void changecolor()
{



string SqlConnect = System.Configuration.ConfigurationManager.ConnectionStrings["Connect"].ConnectionString;
SqlConnection Sqlconn = new SqlConnection(SqlConnect);
SqlCommand sqlcomm = new SqlCommand("select * from Addstock", Sqlconn);
Sqlconn.Open();
SqlDataReader dr = sqlcomm.ExecuteReader();
if (dr.Read())
{


foreach (RepeaterItem item2 in Repeater1.Items)
{

if (Convert.ToInt32(dr["Quantity"].ToString()) > 1)
{
HtmlTableCell td = (HtmlTableCell)item2.FindControl("TD1");
td.BgColor = System.Drawing.Color.Green.ToString();
//td.Attributes.Add("style", "background-color:Green;");

}

}
Repeater1.DataSource = dr;
Repeater1.DataBind();

dr.Close();
Sqlconn.Close();

}


}

here is my code sir but its not working :( can u help me plz

yes exactly i want this which you mentioned above sir.

Buddy Sorry But i'm not arrogant look above comment that guy said that "And it was so urgent you forgot to ask a question in your haste? How is any of this a problem? Do you not know how to connect to your database (whatever it is)? Do you know know how to write a query? Do you not know how to execute a query?" this thing made me sad thats y i said to him not to comment its not for you Buddy :(

string SqlConnect = System.Configuration.ConfigurationManager.ConnectionStrings["Connect"].ConnectionString;
SqlConnection Sqlconn = new SqlConnection(SqlConnect);
SqlCommand sqlcomm = new SqlCommand("select * from Category", Sqlconn);
Sqlconn.Open();
SqlDataReader dr = sqlcomm.ExecuteReader();
if (dr.HasRows)
{

DropDownList1.DataSource = dr;
DropDownList1.DataTextField = "CatName";
DropDownList1.DataValueField = "Catid";
DropDownList1.DataBind();

ListItem c = new ListItem("Select Category", "0");
DropDownList1.Items.Insert(0, c);
ListItem d = new ListItem("Select Warranty", "0");
DropDownList2.Items.Insert(0, d);



dr.Close();
Sqlconn.Close();
}

this code can tell u what i know and if u want to help then Welcome.

Thanks Buddy i got the solution :)

how to convert
var timeSpent = sw.ElapsedMilliseconds.ToString();
milliseconds to seconds i want to show result in seconds can u help me?

yeah...Buddy Thanks :)

i got the solution Buddy u also helped me
<ul runat="server" id="hide">
<li> <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="userwelcome.aspx">My Page</li></ul>

i added runat="server" and id to my <ul> tag then set the visibility false when session is null .
if (Session["email"] == null)
{

HyperLink1.Visible = false;
hide.Visible = false;


}
else if (Session["email"] != null)
{


HyperLink1.Visible = true;
hide.Visible = true;


}

how to hide Li tag as we hide linkbutton like linkbutton.visible=false;
but there is no li server tag present ...

i want to bind data on button click and its working fine but when it shows searched result and if i make textbox blank and then again click on searchbutton then it is showing last search result.

Thanks...Buddy :)

Thanks..

Thanks

So what should i do in order to get design time tool?any download link?

Solved..

Thanks

Thanks sir i got it :)

oh again Sorry Mam :(