Comments by Bh@gyesh (Top 141 by date)

+20... :)

Chceck your master page. It must contain <Form> tag. If not, put <form> tag.

no issue. you can use window service..

You can use window scheduler also for this task. the main thing is sending mail before one week so, there should be some application running on your system that will check for date validation without it this thing u need to do manually.. :)

Refer "http://forums.asp.net/t/1381378.aspx?page+method+versus+webservice+"

Make window service for sending mail and write your logic for date compare and send email within it. It will solve your problem.

Hi, Use System.Numerics.BigInteger. Mau be it can solve your problem. :)

Where you are hosting your application? i.e. you need to change connection string in web.config file. Can you please provide more information abt SQL connection?

May be you havn't installed Framework 4.0 so its showing you this line. Change this version with your existing one or install frameowork 4.0

Check your insert query is properly generated or not? Try Dinesh's answer to build 3rd parameter i.e. productitems

Which error?

textbox1.text = DAteTime.Now().Date();
textbox2.text = DateTime.Now().Time();

What is written in your "GetTaxdetails()" function? PAss parameter in this function

here, you need to write this condition in SQL query or SP from which you get datatable.
Pass date parameter in query or sql so you will get result depending on your condition. and then bind result set to grid.

http://forums.asp.net/t/1123576.aspx?how+to+set+required+field+validator+with+DropDownList

Change InitialValue property with your value field i.e. "0" or "-1" whatever your value for "-Select-".

Hi,
If I understood you correctly then following may be your solution :

string test="xred Milawa Blue";
int index1 = test.IndexOf("xred");
int index2 = test.IndexOf('xred', index1 + 1);
string result2 = test.Remove(index1, index2 - index1);

Thanks.

Why you need to calculate onLoad function. You can use textchange event of textboxes.

I think you have not included "LOANMASTER" table in query. Add it.

in which event you access this? can you share me your code?

It means you are checking CStartEnd.Checked and it shows false instead of true, isn't it?

Create one object like objtextbox1 in form 2, assign it so when form2 is load, you can assign it to textbox resides in form2

It is good if you share your code here. but you can try following in your SP or query which is used to bong datagrid :
SELECT * FROM myTable ORDER BY Year(myDateColumn), Month(myDateColumn)

You need to do sorting on year also. so have written this type of query

I created an application like your code and it is working..

Is it working or not?

Ahh, is this code in "if(!Page.IsPostback)" condition?

Open reading means the initial (first) reading of the day. and close reading means last reading for that day. Last reading is become open reading for next day.

Open reading means the initial (first) reading of the day. and close reading means last reading for that day. Last reading is become open reading for next day.

Add RowDataBound event in grid and register buttonclick event in that.

Eg.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Button btn = (Button)e.Row.FindControl("btnSelect");
btn.Attributes.Add("OnClick", "opentab();");
}
}

and remove "btnlink.Attributes.Add("OnClick", "opentab();");" line from RowCommand event.

post your code here

trim() is used to delete extra spaces from end of text.
For eg. if you have entered "12 " in textbox1 then it will trim leading spaces from text and take only "12" in further consideration.

Do you have any render or prerender event? I have tried at my side and it is working fine.

Have you tried "EnableViewState = True" in dropdownlist?

Add property - EnableViewState = True in dropdownlist.

Ideally, when u click on button the selectedindexchanged event must not be called. IT should called only when you change selected items from dropdown.
Can you share your code here?

SelectedIndexChanged event fires only when you change item in dropdownlist. It will not fire on initial formload postback.

Have you explicitly call this event in page_load event?

Which error you got?
Add LocationName in Group By clause

Have you tried with Ajax and JQgrid? With JQuery I have tried and It took 5 to 7 second to load data in lakhs.
You have to use AJAX with this option.

Use JQgrid instead of simple grid. It will definitely improve performance.
http://trirand.com/blog/jqgrid/jqgrid.html

on which line u get error?

Add btn.Autosize = true option .If it is not working then replace code of button2_MouseMove event with following code :

Button button = (Button)sender;
if (e.Button == MouseButtons.Left)
{
button .Left += e.X - move.X;
button .Top += e.Y - move.Y;
}

So you can use enable / disable button on this. When user click Start, all other buttons are enabled and when user click stop, all other buttons are disable

Var type can take any datatype which is assigned it first. here item is var type so it is assigned as checkboxlist object.

You are passing keysubject as argument with int type conversion but item is an object type. so I think it is invalid. You should pass some other value i.e. item.count or item.selectedvalue etc...

Please more elobrate your question? on which application are you working win / web ?

Can you tell me exactly which error you are getting?
Second thing - try to debug the application and see the path you are getting at runtime is right or wrong? and please paste that path here.

if you are accessing path with ip address then, that folder must be shared. Do one thing neeraj, Share uploads folder and then try.

Lokesh, I think niraj trying to access folder from server which is not part of applicaiton.

Niraj, Can you tell me which error are you getting?

It means Your application and image location are on different server? i.e. upload folder is not part of your application?

Refer http://www.c-sharpcorner.com/uploadfile/mahesh/application-startup-and-executable-path/

if you have doubt let me know

Use Application.StartupPath

if this is web application then use server.mappath to get file. It will give you application path.

Which error u get?
Try Image.FromFile("\\192.168.2.125\\Uploads\\9240.jpg")

try to call validate event on "onpaste" event instead of "return false"

Try to increase "ConnectionTimeout in web.config. If it is not working then, try to increase commandTimeout in command property.

Hi,
Can you pase code of your SP? So I can update it accordingly what you want.

where do you stuck in code? Where is the problem? Please provide more information.

From your code it seems that you have not written select statement at end. i.e. if you want to select error message, then you need select statement.

Add following line at before END :

SELECT @p_error_msg

Regards,
Bhagyesh

From code it seems that, there is syntax error. Try following :
1) Add space after "From" word
using (SqlCommand cmd = new SqlCommand("select from " + coursetype + "where UID = @UID", con)

2) Add space after "From" word
string insertQuery = "DELETE FROM " + coursetype + "WHERE UID = '@UID'"

Let me know in case of any query.

Bhagyesh

Where do you stuck in code?

Hi,
Howmany rows your gridview has?

Hi,
Here, First of all, debug your code and identify howmany records fetched in reader?
second thing. You are storing element in list but where do u assign list items to grid?

Try to print '@vQuery1' and '@vQuery' and see does it built correct query? i.e. any syntax error?

1) Are you passing any parameters to APIs?
2) "Content of API" means result of API? or whole content of API?

What is the requirement for opening content of hyperlink in textbox?

I dont understand your question. Does it mean you want to open google.com in textbox?

Hi,

Refer link :
http://stackoverflow.com/questions/19854502/unsubscribe-option-in-email-using-c-sharp

Thanks CHill for information.

I can not clear textboxes in else part. If doing this it will take empty value though I have entered value in those textboxes.

Hi, Sorry. I am not getting how to use improve solution?

<div><br><br>
<table><br><br>
<tr><br><br>
<td><br><br>
Text1 : <asp:TextBox ID="txt1" runat="server" EnableViewState="false" ViewStateMode="Disabled"><br><br>
</td><br><br>
<td><br><br>
Text2 : <asp:TextBox ID="txt2" runat="server" EnableViewState="false"><br><br>
</td><br><br>
<td><br><br>
Text3 : <asp:TextBox ID="txt3" runat="server" EnableViewState="false"><br><br>
</td><br><br>
<td><br><br>
Text4 : <asp:TextBox ID="txt4" runat="server" EnableViewState="false"><br><br>
</td><br><br>
<td><br><br>
<asp:Button ID="btnsubmit" Text="Submit" runat="server" OnClick="btnsubmit_Click" /><br><br>
</td><br><br>
</tr><br><br>
</table><br><br>
</div><br><br>
 <br><br>
<br><br>
protected void Page_Load(object sender, EventArgs e)<br><br>
{<br><br>
<br><br>
}<br><br>
 <br><br>
protected void btnsubmit_Click(object sender, EventArgs e)<br><br>
{<br><br>
 <br><br>
......<br>
txt1.Text = string.Empty;<br><br>
txt2.Text = string.Empty;<br><br>
txt3.Text = string.Empty;<br><br>
txt4.Text = string.Empty;<br><br>
 <br><br>
}

Not working

Not working as jquery is called after server call, so at server side at refresh time it retains value. :(

Already tried Not working...

Not working dude... I have checked all solutions..

No..

Thanks for the link but it will fire postback unnecessary (i.e. twice for one buttonclick)

AutoComplete="off" is not working Sorry :(

yes but not working :(

Thanks for the link but not found solution..!

Thanks for reply Siva.
The problem is when I refresh page in debug mode, so I can see the textbox value in pageload event.
for eg.
I have buttonsubmit event in which I save the records and clear the textboxes like following

protected void btnsubmit_Click(object sender, EventArgs e)
{
<save content="" code="">
....
...

// Clear controls
txt1.Text = string.Empty;
txt2.Text = string.Empty;
txt3.Text = string.Empty;
txt4.Text = string.Empty;

}

Now, when I press refresh, control comes to this event in which I get old values for all textboxes.
I dont want old values. I want empty values, so validation would be fired.

Let me know if you have any doubt.

Elaborate more your question with example.

yes that's right Richard but if someone forgot or not taken any backup so is there any provision to retrieve this password?

Hi,

Get your imagebuttons exact id (i.e. like 'ctl00_ContentPlaceHolder1_ImageButton1') and add below line in document.ready event :

document.getElementById('ctl00_ContentPlaceHolder1_ImageButton1').style.visibility = "hidden";

Hi,
Please check following points :
1. Check whether your project is successfully built or not? (Rightclick on solution -> click on build)
2. Set first page as your startup page. (Rightclick on webpage -> click on 'set as startup page').

if both above mentioned point is verified then also your webpage is not shown in browser then do following :
Rightclick on startup page -> browse.

Hi Arkadeep,
Here we need to check your service is calling or not? means so call messagebox or something which can sure us function is calling.
If it successfull, then there must be some issue in mail sending.

Regards,
Bhagyesh

Please specify your error. "doesn't work" is not enough.

Hi,
You can get client browser locale (language). It ultimately give u date format for client machine.

Please specify your requirement, so I can assist you further...

Hi,
You can know the browser culture of client machine. From culture you can know the datetime format.
Specify your requirement so I can help you further..

Create gridview property in page2. see below :
Page1 :
//Calling page2
this.Hide();
frmpage2 pg2 = new frmpage2(objgridview);
pg2.Show();

Page 2:
public gridview objgridview
{
get { return objgridview }
set { objgridview = value; }
}
This code is for your reference. It may contain some syntax error.

Hi Devendra,

I have tested following scenario in SQL and its working fine :

declare @test nvarchar(max)

Set @test = N'सहाय'

INSERT [dbo].[Table_1] ([Test], [Test1]) VALUES (N'3', @test)

So, Add 'N' as following in your code
cmd.Parameters.AddWithValue("@firstName", 'N'+txtName.Text);
cmd.Parameters.AddWithValue("@middleName", 'N'+txtMiddleName.Text);

etc...

and remove 'N' from parameter list.

Let me know in case of any issue...

Want to add something in Jas' solution.

cmd.Connection = cn;
cn.open();

At last you can add :
cn.Close();

Please refer following link.

http://p2p.wrox.com/general-net/18997-get-popup-window-value-without-refresh.html

Use lock mechanism available in SQL. Refer following articles for locking
http://technet.microsoft.com/en-us/library/aa213039(v=sql.80).aspx
http://www.sswug.org/articlesection/default.aspx?TargetID=16921

You can search on google for "EMS" (Employee Management System). You will definetly get some help from there.

Happy Coding :)

Check your dataset. it should not be NULL.

Ok, Please refer following link. It will show how to insert data in database.

http://aspsnippets.com/Articles/Simple-User-Registration-Form-Example-in-ASPNet.aspx

Let me know if you have any doubt.

Hi,
Which datatype you are using to store mobile number? Please share your code so I can suggest you which changes or enhancement required.

Hi,
Does it mean without providing mobile number data can not be save in database? i.e. Messge will be shown to user "Please enter mobile number" like this?

Hi,
Use 'OR' instead of 'AND' in query.

ok, For that you need to check for every column exists of not in table.

SELECT CASE WHEN exists (SELECT * FROM sys.columns
WHERE [name] = N'column1' AND [object_id] = OBJECT_ID(N'table') THEN Column1 ELSE NULL END) AS 'Column1',
CASE WHEN exists (SELECT * FROM sys.columns
WHERE [name] = N'column2' AND [object_id] = OBJECT_ID(N'table') THEN Column2 ELSE NULL END) AS 'Column2'

FROM TableName

Hi Sudhakar,
Please refer following link to create SSIS packages.
http://www.codeproject.com/Articles/402958/SSIS-Package-Export-Data-from-Database-Daily-to-Ne
http://www.youtube.com/watch?v=CJI6pPueyzM

Thanks,
Bhagyesh

Please share your error.
Use transaction thing instead. So If any statement will fail, hole transaction will be rollback.

Do one thing,
1) Debug your application.
2) Add "FS" variable in watch.
3) see the value of FS runtime and check wether the path is correct or not?

if possible paste your path here.

Updated:
SELECT SCode, Issuing_date, SUM(panch_Amount) as 'PanchAmount',
SUM (Org_Amount) as 'OrgAmount'
From table
GROUP BY SCode,Issuing_date

Refer link :
http://stackoverflow.com/questions/146134/how-to-remove-illegal-characters-from-path-and-filenames

Do u mean to say delete column of delete a row based on some column value?

Hi,
What does it mean - " 8 rows in one column"?
can you give some example?

Hi,
Which error did you get while executing code?

Hi,
Give details in questions. does it means, you select '1' then one textbox, '2' then 2 textboxes etc..?

Refer following link
http://www.codingfusion.com/Post/Repeater-Edit-Update-Delete-in-Asp-net-using-Ado

I am not getting your question. Can you please state scenario why you want this?

Replace line "objbll.insertrecord(objbo);" with "objbll.FindRecord(objbo);. It may be solve your problem.

Hi,
If I understood correctly your question, then you want redirection of different page depending upon role?
if yes, then you can do as following.
if (role='admin')
Response.Redirect("Page1.aspx");
else
Response.Redirect("Page2.aspx");

Hi,
What is limit for SAL field. means how many star should come when SAL is going beyond 4 digits (10000, 100000, 500000 etc..)

Hi,
In code --> in "btnfind_Click" event, you are actually inserting records in table not (objbll.insertrecord(objbo)) finding is it right code?

Hi,
You mean to say when an entry inserted in employee table, one entry must be inserted with Artist table with newly inserted employeeid is it?

Hi,
Its working at my side. Do as follows:
1) Add following stylesheet in your page under <style> tag
.HeaderStyle
{
font-family:verdana;
font-size:x-small;
position:absolute;
margin-left:0;
}

2) Now, following is gridview declaration in .aspx page.
<asp:GridView ID="GridViewSRL" runat="server" AutoGenerateSelectButton="True" OnLoad="GridViewSRL_Load" AllowSorting ="true" OnSorting="GridViewSRL_Sorting" HeaderStyle-CssClass="HeaderStyle" AutoGenerateColumns="true" OnRowDataBound="GridViewSRL_RowDataBound">


3) Add rowdatabound event in .cs file
protected void gvDistricts_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.RowIndex == 0)
e.Row.Style.Add("height", "50px");
}
}
now check.

Hi,
see final result you want as an array with not null and empty records. Now if you delete element from an array using forloop, so it will give error as you can't change collection runtime.
So I suggested another array which will store your required result.

Can you please paste your code?

Hi,
For chating application you can use "SignalR", available in .NET. Please refer following link.
http://dhavalupadhyaya.wordpress.com/tag/chat-application-using-signalr/

Hi,
Can you please more elaborate with your question?

Hi,
Following code will help you to pass parameters using JQuery.
$.ajax({
url: <your api="" address="">,
type: "GET",
contentType: "application/json; charset=utf-8",
dataType: "json",
data: JSON.stringify({<parameter> }),
success: function (data) {
<do whatever="" you="" want="" with="" your="" result="">
}

Hi Harpreet,
When you deploy your application on IIS, It will take identity of IIS user, not logged in user. From connection string it seems that your are using window authentication for SQL server but it is not possible from IIS.
So pass userid and password in connection string. It may resolve your problem.

Hi,
here you stated that, your table has only two row. so you can not check "if (dt.Rows[2][0].ToString() == String.Empty)", it will throw an error, as it check for third row but it does not exists in table. So remove that line. You can also use forloop for this operation.

Hi,
You can use jquery insted. First of all in docun=ment.ready method, make textbox enable false so when page is postback it will remain enable false.

Please specify your requirement in detail. Means you want to display data from database?

Pass data with JSON.strigify method. JSON.strigify(data)

Hi,
Is it your window application or web application?
Try : Process.Start(pathoffile);

Hi,
can you please more elaborate with your question?
One thing you can do, you can save one form value in session or pass with querystring to another form. then on final form you can insert records in two tables.

Hi,
The reason is, when u declare any server side control event (i.e. linkbutton click), the code behind function should know from which control this even thas been called.
If you have idea of delegates so you can understand very well of this concept. Actually sender has all properties of control has been called.
This mechanism is called event handler.

You can get more idea from following link:
http://msdn.microsoft.com/en-us/library/aa645739(v=vs.71).aspx
http://msdn.microsoft.com/en-us/library/system.eventhandler.aspx

Hi,
If you are dealing with window application then you can print easily wih the use of lib.
If there ia aweb application then, you can export that grid data in PDF and from PDF you can print.

Ok, I got what you want. you can refer following link to insert new row in grid with controls.

http://geekswithblogs.net/dotNETvinz/dotNETvinz/archive/2009/06/29/faq-dynamically-adding-rows-in-asp-table-on-button-click.aspx

http://geekswithblogs.net/casualjim/archive/2006/05/04/77151.aspx

if you are comfortable with javascript so you can use following link.

http://webcache.googleusercontent.com/search?q=cache:http://stackoverflow.com/questions/8490231/grid-view-add-new-blank-row-for-entry

So you can do one thing.
Select all records in datatables in asp.net. then filter records according to conditions.
Please refer following links :

http://stackoverflow.com/questions/13012585/how-i-can-filter-a-datatable
http://www.csharp-examples.net/dataview-rowfilter/

Please mark as answer if you found this useful..

If I understood correctly, you want all records from db (students information) and filter them i ASP.NET side, true?