Comments by Member 9581488

Member 9581488 27-Jun-13 16:36pm View

I recently used EPPLUS and it works much faster than stringwriter and htmlwriter. Moreover to that You can customized your data as well. like in dateformat,decimal,percentage and so on.Go to this link and it might be helpful. epplus.codeplex.com

Member 9581488 27-Jun-13 16:25pm View

Post your stored procedure as well. Are you trying to insert any value which is of datatype double and you pass it as DateTime?

Member 9581488 26-Jun-13 16:17pm View

http://msdn.microsoft.com/en-us/library/office/cc880096.aspx Please refer this link. It has mergeCell function. Might give you an idea

Member 9581488 25-Jun-13 15:02pm View

didnt work either.

Member 9581488 24-Jun-13 15:05pm View

This shows me the value like :6666.67%
I am looking for correct format.

Member 9581488 14-Jun-13 15:02pm View

Yes the large datatable is from database tables and excel is throwing out of memory exception. Also I have them all created dynamically so I cant manually set header and row style in excel.

Member 9581488 19-May-13 19:11pm View

Adpt.Fill(dt); after this line
dt.rows.count == 0
{
// your message here!
}

Member 9581488 19-May-13 15:54pm View

On what line you are getting error?

Member 9581488 17-May-13 12:13pm View

http://sqlfiddle.com/#!2/3ea58/5 check this link and see if its returning your desired result in output

Member 9581488 17-May-13 12:08pm View

are you getting any error or its returning all rows?

Member 9581488 17-May-13 12:02pm View

Change dates!

Member 9581488 17-May-13 11:57am View

select top 10 slsmName,
sum(NetAmt)
from salesDetails
where slsDate between '03/15/2012'
and '5/17/2012'
and bilStatus=true
group by slsmName,totalAmt
order by totalAmt desc;

Try above query

Member 9581488 17-May-13 11:41am View

Can you please share your test Data?

Member 9581488 17-May-13 10:56am View

Deleted

Add Group by slsmName

Member 9581488 17-May-13 10:26am View

what is the value of name? try using break point.

Member 9581488 16-May-13 20:07pm View

thank you..but I have given the user other options as well.....and sometimes SQL statement doesnt work if it finds any spaces so I have given HINT!

Member 9581488 16-May-13 15:32pm View

You have extra space at :- cmd = new SqlCommand("GetCustomerByName ", con); remove the space after GetCustomerByName
else Use breakpoint and see the value of name
and try below command to your SQL Server query window and see if its returning any value.
exec GetCustomerByName YourCustomerName

Member 9581488 16-May-13 14:11pm View

Group by member_id,Member_no
try above and see if it works

Member 9581488 16-May-13 14:05pm View

If objSelfReportedSales.Items.Count.ToString > 0 Then
grdComcast.DataSource = objSelfReportedSales.Items
grdComcast.DataBind()// after this line call your export method.
grdComcast.Visible = True
lblMessage.Visible = False

Member 9581488 15-May-13 13:34pm View

are you looking for some SQL query to populate desired result?

Member 9581488 15-May-13 13:09pm View

oh.. not you! my mistake.....its for Kinjal Noko

Member 9581488 15-May-13 12:34pm View

You can export your grid to excel after binding data to gridview.

Member 9581488 15-May-13 9:15am View

http://jqueryui.com/animate/#default the link might give you and idea..!

Member 9581488 8-May-13 11:57am View

Is your method returns the required data?
cation: 'EmplyoeeDetails', // it should be caption:
Are you getting any error in console?

Member 9581488 7-May-13 9:53am View

post your code!

Member 9581488 3-May-13 10:07am View

So you got the result set binded to datagrid using datasouce?

Member 9581488 3-May-13 9:22am View

OR you can combine your functions into one!
instead of passing only one value...pass multiple values in function and loop through each in your class file. Hope you get my point.

Member 9581488 3-May-13 9:06am View

DataTable DTResult = new DataTable();
DTResult.Merge(dt);
DTResult.Merge(dt1);
DTResult.Merge(dt2);
DTResult.Merge(dt4);
DTResult.Merge(dt4);
DTResult.Merge(dt5);
DTResult.Merge(dt6);
dataGridView1.DataSource=DTResult;

Try above code and see if you are getting desired output or not.
You cant call two functions on one datatable because it will overwrite your data in datatable.

Member 9581488 2-May-13 12:04pm View

If you have 6 different table and want to get the result set based on common column name then instead of having six separate SQL statement you can join them together and hence you dont have to call function 6 times!

Member 9581488 2-May-13 12:02pm View

dtcmd is datatable here.
post your code and I may guide you whatever you want to achieve

Member 9581488 2-May-13 11:54am View

DataTable DTResult = new DataTable();
DTResult.Merge(dt);
DTResult.Merge(dtcmd);
dataGridView1.DataSource=DTResult;

the above code worked for me. I tried with 2 datatables.

Member 9581488 2-May-13 11:17am View

Oh, I misunderstood it. I thought its web-based application.But you can assign the ResultDataTable to your datagrid! I m not yet sure!

Member 9581488 2-May-13 11:15am View

SELECT Subjects.SubjectId,Subjects.UserId,AgePeriods.Period From Subjects
INNER JOIN AgePeriods ON Subjects.CID = AgePeriods.AgePeriodId
WHERE CId = '" + TypeId + "'
ORDER BY Subjects.SubjectId

Use above query

Member 9581488 2-May-13 9:17am View

if you have two tables then you should use join!
http://www.w3schools.com/sql/sql_join.asp
the above url might help you!

Member 9581488 16-Apr-13 15:53pm View

Glad to help you!
for session variables:-
please refer this link
http://msdn.microsoft.com/en-us/library/ms178581(v=vs.100).aspx

Member 9581488 16-Apr-13 15:45pm View

select COUNT(*)as Result
try putting this!

Member 9581488 16-Apr-13 15:18pm View

SELECT user_id,passwd,empcode,dm.division_id,u.unitcode,sm.pc_code from register,division_master dm,unit_master u,sba_master sm where user_id=@user_id and passwd = @passwd and empcode = @empcode and division_id = @division_id and unitcode =@unitcode and pc_code =@pc_code

change the above query to following one:
SELECT COUNT(*) from (TabelName) where user_id=@user_id and passwd = @passwd and empcode = @empcode and division_id = @division_id and unitcode =@unitcode and pc_code =@pc_code

The count will return 1 if it finds match!

Member 9581488 16-Apr-13 15:16pm View

You forgot to put @ in division_id,unitcode,pc_code!
use breakpoint and see what is the value of resilt.

Member 9581488 16-Apr-13 14:09pm View

Where username=@user_id and so on(rest of the fields here to get the exact match)...
and change the code
cmd.Parameters.AddWithValue("user_id", txtuserid.Text);
to
cmd.Parameters.AddWithValue("@user_id", Convert.ToString(txtuserid.Text));

Member 9581488 16-Apr-13 13:55pm View

Moreover, I think you have SQL statement just for selecting records from table! You dont have WHERE clause in your SQL query and you are passing arguments with some textbox and dropdown values.
If you want to verify the username and password you have to use WHERE clause in SQL Query !

Member 9581488 16-Apr-13 13:51pm View

Try it and you will at least get hint where is the error or why its not redirecting!

Member 9581488 16-Apr-13 13:48pm View

Have you tried debugging with break-point?

Member 9581488 16-Apr-13 13:26pm View

are you getting any error?

Member 9581488 3-Apr-13 9:31am View

Try using some other text for commandname="SelectData" and try!

Member 9581488 30-Mar-13 12:18pm View

can you use break-point and see what is the value of ddlcity.selectedValue?

Member 9581488 30-Mar-13 11:59am View

share your sql insert statement.

Member 9581488 29-Mar-13 12:13pm View

so....i hope you are good to go now....:)
Happy coding...:)

Member 9581488 29-Mar-13 11:23am View

I believe you have idea how join works....
what does the following statement do?
state.state_id = city.state_id
please share your table structure.

Member 9581488 29-Mar-13 10:45am View

how many ids you have in your registration table?

Member 9581488 29-Mar-13 10:28am View

thats what i m saying you...its not returning any value!!! so how will it bind to detailsview fields.

there might be some minor mistake when you try joining 2 tables!!
there is no mistake in your c# code. I tried with it and its working fine! so I guess its query thats having some issue!

Member 9581488 29-Mar-13 9:50am View

SELECT registration.user_id, registration.firstname, registration.lastname, registration.username, registration.state_id, registration.city_id, registration.pincode,
registration.mobile_no, registration.phone_no, registration.e_mail, registration.address, registration.reg_date, state.state_name, city.city_name
FROM registration INNER JOIN
state ON registration.state_id = state.state_id INNER JOIN
city ON registration.city_id = city.city_id AND state.state_id = city.state_id

WHERE registration.user_id=1

run this query and see is it returning any values?

Member 9581488 29-Mar-13 9:50am View

Deleted

SELECT registration.user_id, registration.firstname, registration.lastname, registration.username, registration.state_id, registration.city_id, registration.pincode,
registration.mobile_no, registration.phone_no, registration.e_mail, registration.address, registration.reg_date, state.state_name, city.city_name
FROM registration INNER JOIN
state ON registration.state_id = state.state_id INNER JOIN
city ON registration.city_id = city.city_id AND state.state_id = city.state_id

WHERE registration.user_id=1

run this query and see is it returning any values?

Member 9581488 29-Mar-13 9:43am View

you said its not working when you pass id other than 10.
so your table does not contain any data with other ids except 10.

Member 9581488 29-Mar-13 9:39am View

so it means you dont have any data for ids other than 10.
if it does not find any data..then how will it bind with detailsview!!
hope your problem is solved!!

Member 9581488 29-Mar-13 9:36am View

change cmd.Parameters.AddWithValue("@user_id",1); to
cmd.Parameters.AddWithValue("@user_id",10);
and see if it binds the data with detailsview

Member 9581488 29-Mar-13 9:30am View

in your sql's query analyzer.

Member 9581488 29-Mar-13 9:17am View

exec usp_profile @userid=1
run this command in your sql management studio and see if its returning any result set.

Member 9581488 29-Mar-13 9:10am View

Deleted

You are not executing your stored procedure...... cmd.ExecuteNonQuery() before you bind it to detailsview!

Member 9581488 27-Mar-13 10:15am View

You have boundfield for stateid and cityid...
But when user edits it it has to be edit template....so if you bind your city and state with dropdown, User can modify it if you use edit template( if that is your requirement)

Member 9581488 25-Mar-13 16:04pm View

http://msdn.microsoft.com/en-us/library/ms173114.aspx

Please refer above link and see how it returns the required value at the end of the function.
You can apply the same for your required value.

Member 9581488 25-Mar-13 15:45pm View

To Suggest you further I require more details.

Member 9581488 25-Mar-13 15:44pm View

I suggest you to use join for displaying statename and cityname.
here You are binding it with state_id and city_id so of course, it will bind it with that value only.
1) Join 2 tables
2) bind your required field to your webcontrols
3) I suppose your end user is able to edit the records. So for that You have to use edit template where you have boundfields for cityid and stateid.

Member 9581488 25-Mar-13 9:28am View

It would be better if you share your code.
How you are binding your dropdown? datatextfield=?

Member 9581488 25-Mar-13 9:13am View

Try Joining two table. (say for exp:- userdetails and StateDetails join them with stateid)
Are you using dropdown for displaying that??

Member 9581488 19-Mar-13 10:08am View

where you are binding your gridview to respected datasource?

Member 9581488 18-Mar-13 14:39pm View

post your aspx dropdown code and one panel code.

Member 9581488 18-Mar-13 9:53am View

Make one boundfield in your gridview and bind it with your SlNo field, If you do not want user to see that fields you can make it visible="false".
I found out you do not have any itemtemplate or boundfield that actually binds your field to grid.
Hope this hint helps you.

Member 9581488 14-Mar-13 9:34am View

Glad to help you!

Member 9581488 13-Mar-13 16:20pm View

its working when
set @order_id=@subitem_name+convert (nvarchar(50),DAY(getdate()))

exec str_order 'asdd','test',10.2 --runs perfectly fine.

Member 9581488 13-Mar-13 16:03pm View

Did you tried the solution that I posted?

Member 9581488 13-Mar-13 15:48pm View

so the error is in his stored procedure where he is setting up the value of @order_id.

I replaced line set @order_id=@subitem_name+DAY(getdate()) with
set @order_id=@subitem_name
then execute stored procedure

and now if i run
exec str_order 'asdd','test',10.2

its inserting data....

Member 9581488 13-Mar-13 15:45pm View

your day(getDate()) is taking value of 13 or some integer and you are converting it to @order_id which is nvarchar in your stored procedure as well as in your table.!! check that out!!!!

Member 9581488 13-Mar-13 15:41pm View

I tried your stored procedure. when you comment out the lines:-
--declare @entrydate date
--set @entrydate=GETDATE()
--declare @time time
--set @time= CURRENT_TIMESTAMP
--declare @order_id nvarchar(50)
--set @order_id=DAY(getdate())

Its working fine....so there is error when you set the @order_id Field.

Member 9581488 13-Mar-13 15:32pm View

insert into Jin_order(subitem_name,item_descript,item_rate,entrydate,time,order_id)values(@subitem_name,@item_descript,@item_rate,@entrydate,@time,@order_id)

In stored procedure what is the exact value its taking for @order_id

Member 9581488 13-Mar-13 15:26pm View

try passing some static value and see if your stored procedure is correctly working or not!!

cm.Parameters.AddWithValue("@subitem_name", "test"); and so on....

Member 9581488 13-Mar-13 15:14pm View

try converting it to string.

Member 9581488 13-Mar-13 14:08pm View

decicaml item_rate = Convert.ToDecimal(lbl3.text);
should be
decimal item_rate = Convert.ToDecimal(lbl3.text);

Member 9581488 13-Mar-13 14:04pm View

Read the explanation in answer by SA.
If you cant troubleshoot the error, Try passing some static values to it.

Member 9581488 13-Mar-13 13:52pm View

what is the value of Session["item_rate"]?

Member 9581488 13-Mar-13 13:47pm View

Session["item_rate"] convert this to int if your @item_rate datatype is int.
Double check your datafield's datatype in database as well as in C# when you pass it to database.

Member 9581488 1-Feb-13 14:08pm View

thank you..Its working now.I thought we have similar kind of accessibility for gridview columns like we have for row.
Thank you!

Member 9581488 1-Feb-13 13:50pm View

GridView2.DataKeys[row.ID]
error : some invalid arg

Member 9581488 30-Jan-13 11:52am View

try running simple show and hide code for test & see if that works else that files are not getting references properly..try changing src="./Scripts/jqFancyTransitions.js" to src="../Scripts/jqFancyTransitions.js"

Member 9581488 30-Jan-13 11:17am View

Are you using jQuery? if yes, Have you include related reference files?

Member 9581488 26-Jan-13 19:10pm View

I added you in yahoo....
please accept req

Member 9581488 26-Jan-13 19:04pm View

Please wait i wil b online in a bit

Member 9581488 25-Jan-13 16:29pm View

No its not that difficult as you think. I want to help you out.
is there any other way we can communicate?
please dont cry!!!!!

Member 9581488 25-Jan-13 13:07pm View

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="pid" DataSourceID="SqlDataSource2" OnRowDeleting="GridView1_RowDeleting" Width="460px">

<asp:Button ID="Button4" runat="server" Height="29px" CommandName="Delete"
style="font-weight: 700; font-size: medium" Text="Delete" Width="183px" />

in code behind:-
protected void gvAcceptanceStatus_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Access your PID here using datakeynames (I told you in Your earlier post)

// Your sql code.
// Gather all the files names using sql select query passing PID & save it in dataset.
// Pass that PID in your SQL delete query (remember you have to join two tables because you have relation defined on that table)
// Execute your sql statement and Bind Grid Again

// Here delete files ( records from dataset) in your folder.
}

let me know if it does not work for you.

Member 9581488 25-Jan-13 9:40am View

what is the error??

Member 9581488 25-Jan-13 8:58am View

You want to delete it when you click on delete in gridview but the image that is displayed on gridview is just one image file or multiple because in your question you have mentioned relation between 2 tables.

Member 9581488 24-Jan-13 11:54am View

You have to find out file names that need to be deleted using select statement (for pImages & fImages) and pass your ID using join . After getting result in dataset or datatable, Loop through each row and find if that file exists in your folder if yes then delete it one by one.
let me know if you still find it difficult.

Member 9581488 24-Jan-13 11:33am View

For deleting in database or in folder?

Member 9581488 23-Jan-13 11:07am View

let me know if you cant do it.
I will def help you out.

Member 9581488 23-Jan-13 10:55am View

Please refer below link:-
http://msdn.microsoft.com/en-us/library/cc148994.aspx
You can pass your PATH(where your file is saved) to find if the file exists, if it does then Delete it!!!!!

Member 9581488 23-Jan-13 9:32am View

Thank you :)

Member 9581488 18-Jan-13 9:41am View

as stated by BC @ CV . Use top 10 in your select statement.

Member 9581488 17-Jan-13 12:37pm View

Deleted

where are you adding line :-
Dropdownlist box=new Dropdownlist(); // this will create actual dropdown

Member 9581488 17-Jan-13 11:03am View

Deleted

see my comment for another hint under your question.

Member 9581488 17-Jan-13 10:54am View

If your id is in INT in sql server then you have to convert it to int before passing it to query.
Use breakpoint and see the query. Run that query in SQL Server Management Studio. You will definitely find error there.

Member 9581488 16-Jan-13 16:49pm View

Thanks to google then.... ppl from around world can communicate.
good luck with your project.

Member 9581488 16-Jan-13 16:39pm View

I am so glad to help you..
good luck!
and thanks for the comment..but I had to use google translation... :)

Member 9581488 16-Jan-13 16:15pm View

I am posting the ans in solution.
because i m not able to copy it in comments.

Member 9581488 16-Jan-13 15:59pm View

Deleted

Member 9581488 16-Jan-13 15:43pm View

Its not accepting large file because it has some default default file size and it depends on which version of .net framework you are using.

Member 9581488 16-Jan-13 15:40pm View

copy this line in your web.config before closing tag of system.web <httpruntime maxrequestlength="2097151">
I am not able to copy that line here!!!!!!

Member 9581488 16-Jan-13 13:24pm View

glad that it helped you!
Happy coding..:)

Member 9581488 16-Jan-13 13:13pm View

string str= @david's query and pass the same value to DataAdapter.

Member 9581488 16-Jan-13 12:52pm View

select m.pcode,m.fyyear,m.date,m.salary,m.ta,m.contigency,m.nrc,m.institcharges,m.others,p.total from monthly m inner join project p where m.pcode=ddlSelectedItemValue on p.pcode=m.pcode
in above query place your dropdownlist selected item value and run it in your sql server.
your table contains value of dropdown or text of the dropdownlist?

Member 9581488 16-Jan-13 11:45am View

check datatype of your variables. they both should match in SQL server as well as in C# when you pass it to query.

try running the query in SQL Server with all the values that you are passing from C#. It will show you an error there if its wrong.

Member 9581488 16-Jan-13 9:05am View

Should I copy it in ans? SO you can accept the ans and close this thread.

Member 9581488 15-Jan-13 19:29pm View

<asp:gridview id="GridView1" runat="server" datakeynames="path">

<asp:boundfield datafield="path"
Visible="false"
headertext="Path"/>

Use the above statements and run your code.

Member 9581488 15-Jan-13 16:50pm View

Another try:
try:
string path = GridView1.DataKeys[gr.RowIndex].Values["path"].ToString();
You have to have Datakeys in your gridview tag and One hidden boundfield with DataField="path"

Hope you understand what i mean.

Member 9581488 15-Jan-13 16:47pm View

Response.TransmitFile(Server.MapPath("Files/5.png")); if this is working then something is wrong when you assign value on this line
string path = GridView1.DataKeys[gr.RowIndex].Value.ToString();
Its not getting proper value of datakeys.
Check your gridview data.

Member 9581488 15-Jan-13 16:16pm View

alright.
give it try.
Response.TransmitFile(Server.MapPath(path)); //change it to
Response.TransmitFile(Server.MapPath("Files/5.png")); and if it doesnt work then try the below line.
Response.TransmitFile(Server.MapPath("~/Files/5.png"));
give it try and respond.

Member 9581488 15-Jan-13 16:02pm View

Do you know how to use debugger??
Use breakpoint and see what is the value of string path. Is it returning some value from database? because error says your file is not found means your path (to find the file) is wrong.

Member 9581488 15-Jan-13 16:00pm View

what is the error?

Member 9581488 15-Jan-13 15:48pm View

Details provided by you is datatype of path. I asked the value of path on this line
string path = GridView1.DataKeys[gr.RowIndex].Value.ToString();

put breakpoint and see the value.

Member 9581488 15-Jan-13 15:36pm View

What is the value of path? Also, You have to define path when downloading file. Where you upload your file?

Member 9581488 14-Jan-13 11:53am View

Its still eliminates maths signs and I dont want it.
I want each value separated.

Member 9581488 10-Jan-13 22:08pm View

Try adding rowcommand in gridview tag.

<asp:GridView ID="gdShowArea" runat="server" AutoGenerateColumns="False"
BorderStyle="None" Height="500px" OnRowDataBound="gdShowArea_RowDataBound" OnRowCommand="gdShowArea_RowCommand"
ShowHeader="False" Width="96px">

Member 9581488 10-Jan-13 22:02pm View

I want to change color of subtraction sign when appending it to txtCreateColumn textbox.
I have bunch of strings in textbox and have to differentiate all of them using different color.
Please suggest.

Member 9581488 10-Jan-13 16:25pm View

Its ASP Textbox like:
<asp:TextBox ID="txtCreateColumn" runat="server" Width="300px">

Member 9581488 10-Jan-13 9:09am View

But my problem is that On pop-up window Submit button I m not saving the session values to database. and After Closing pop-up the parent page is not refreshed( requirement of project)
please advise on this.

Member 9581488 7-Jan-13 12:09pm View

Instead of IP address, try using website name. I would suggest you to use break point and use alert after each line and see where the error comes.
If it shows you empty alert box then its not getting proper data.

Member 9581488 7-Jan-13 10:39am View

just an idea:
url: "http://192.168.1.100:85/HostingService.asmx?op=SETPostJobDetails"
try using
url: "http://192.168.1.100:85/HostingService.asmx/SETPostJobDetails"

Member 9581488 4-Jan-13 12:43pm View

http://www.codeproject.com/Answers/520301/percentageplusvalidationplusinplusjavaplusscript-h#answer2

Dont post duplicate question

Member 9581488 4-Jan-13 11:45am View

check what is the value of projectID. Sometimes it returns empty string from database.

Member 9581488 4-Jan-13 9:41am View

Please Refer following link.
It might help you.

http://elegantcode.com/2009/02/21/javascript-arrays-via-jquery-ajax-to-an-aspnet-webmethod/

I am not so sure but giving you suggestion.

var data = { username: username, password: password , clientid: clientid };
Try using above line. and check that variables for username password and clientid has some values.

Member 9581488 2-Jan-13 13:40pm View

do you have your Identity column's Identity Increment? If you want to insert data without specifying your columnNames use:
insert into tablename(value1,value2,...., so on)
but data types must match.

Member 9581488 21-Dec-12 12:55pm View

Did you change??
parSalary = cmd.Parameters.Add("@Sal",SqlDbType.Money);

or else try running it in SQL
exec insertEmp 'test',1000 --(see if it has any error)

Member 9581488 21-Dec-12 12:46pm View

did it work?

Member 9581488 21-Dec-12 12:46pm View

Deleted

did it work?

Member 9581488 21-Dec-12 10:17am View

Please write in english( so others can read it that you are abusing me)and if you don't know english then this website is not for you.....

Member 9581488 20-Dec-12 14:49pm View

the error says itself "virtual directory not being configured as an application in IIS"
Check out if you have multiple web.config file..If you have delete the duplicate and place original one under root folder of your app.

Member 9581488 20-Dec-12 12:43pm View

Have you tried something?? No-one can do your homework and write code for you...!!!! Instead of asking question here, "Google" it.

Member 9581488 20-Dec-12 12:37pm View

good one....!!
:)

Member 9581488 20-Dec-12 12:25pm View

have you tried anything???

Member 9581488 20-Dec-12 11:59am View

Hope this helps you.
http://stackoverflow.com/questions/6688880/how-do-i-grant-read-access-for-a-user-to-a-database-in-sql-server

Member 9581488 20-Dec-12 11:52am View

are you using any event to update grid?
DateTime date = DateTime.Now;
DateTime ans = date.AddYears(1);

You can use this and update grid.

Member 9581488 20-Dec-12 9:43am View

if you want to set permissions you can go to Database properties and in the new window select permission. Again select your UserName and grant all permission by checking different option!

Member 9581488 19-Dec-12 16:10pm View

$("#<%# divCommentsMsg.CliendID %>").delay(3000).fadeOut(100);
should be
$("#<%= divCommentsMsg.CliendID %>").delay(3000).fadeOut(100);

Member 9581488 19-Dec-12 14:16pm View

If you want to run your application on diff machine. you will need IIS, that will convert your comp to work as server. From another machine you can access your application using ip address.
Google it and you will find multiple solutions.

Member 9581488 19-Dec-12 12:12pm View

Your stored procedure is deleting record when you pass @DESIGN_ID.
if you want to display data then you should use select query to return the result after deleting particular row from the table.

Member 9581488 19-Dec-12 10:18am View

Are you binding gridview again after successful execution of SQL Query?

Member 9581488 18-Dec-12 16:05pm View

Try to connect using IP address of the comp that has Database.
Please go through the link once to check your connection string.
http://www.connectionstrings.com/

Member 9581488 18-Dec-12 13:52pm View

Missing Double quotes
cmd.Parameters.AddWithValue("@gender", "Male");
cmd.Parameters.AddWithValue("@gender", "Female");

Member 9581488 18-Dec-12 11:14am View

Check your connection string here:
http://www.connectionstrings.com/

Member 9581488 18-Dec-12 9:11am View

On selectedIndexChanged event(set autopostback=true) of State Dropdown,Bind Dropdown for District By passing stateID From state dropdown.

Member 9581488 17-Dec-12 20:20pm View

My mistake......declaration of message should take place only once.
thx.Edited my ans

Member 9581488 17-Dec-12 12:27pm View

U mean cell value? as you mentioned first row and second column data.

Member 9581488 17-Dec-12 11:48am View

thank you! that worked....Do have one problem. when i see alert msg data on the page disappears.

Member 9581488 17-Dec-12 11:46am View

Deleted

thank you! that worked....Do have one problem. when i see alert msg data on the page disappears.

Member 9581488 17-Dec-12 9:24am View

Deleted

Please refer following link
http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos/Pagesetup/Add-Row-in-Excel-Workbook-for-C-/VB.NET.html

Member 9581488 13-Dec-12 16:37pm View

Use json Desearialize to Get obj value.
Please refer following link

http://www.codeproject.com/Tips/397574/Use-Csharp-to-get-JSON-data-from-the-web-and-map-i

Member 9581488 13-Dec-12 16:15pm View

Create Json object in insertCirclePeople method. Return json on success and you can grab that Json obj in your success function in AJAX.

Member 9581488 13-Dec-12 15:31pm View

For radiobutton:
if(ds.Tables["Doctor"].Rows[0]["Dgender"].ToString()== "Male")
{
rdoMale.checked=true;
}

Member 9581488 13-Dec-12 14:52pm View

You may use TextChanged Event of textbox

Member 9581488 13-Dec-12 10:38am View

Thank you!

Member 9581488 13-Dec-12 10:38am View

Deleted

Thank you!

Member 9581488 13-Dec-12 9:49am View

On popup Body Onload=="jsFunction()"

Else...

<script>
window.onload = refreshParentPage;
function refreshParentPage() {
window.opener.location.reload();
}
</script>

I am not 100% sure but You can try the above function.

Member 9581488 13-Dec-12 9:36am View

Check value of Loan_id. It should match with the loan_id in loan table. Because it error is about foreign key conflict.
Match both table values (Installments & loan)

Member 9581488 13-Dec-12 9:16am View

You can try the following
=IIf(Parameters!MyField1.Value="Month" And Parameters!MyField2.Value="Sale",
Iif(Sum(Fields!Total.Value) = 0, "Zero sum", "Non-zero sum"),
"Test")

Member 9581488 11-Dec-12 14:12pm View

Not sure but refer the following link
http://stackoverflow.com/questions/8366610/google-maps-js-api-find-name-of-place-given-location-latitude-longitude

Member 9581488 7-Dec-12 16:12pm View

http://stackoverflow.com/questions/3209829/is-it-possible-to-format-a-date-column-of-a-datatable

Refer above link

Member 9581488 7-Dec-12 8:50am View

=IIF(Fields!startdate.value=fields!enddate.value,"Red","No Color")
write this in emp cell.
it will work

Member 9581488 6-Dec-12 22:05pm View

Refer this.Might help
http://stackoverflow.com/questions/495700/can-we-write-a-sub-function-or-procedure-inside-another-stored-procedure-sql-s

Member 9581488 6-Dec-12 9:42am View

does it work if you remove second lblamount?

Member 9581488 6-Dec-12 9:22am View

How do u select a row? What event are you using?

Member 9581488 5-Dec-12 9:14am View

Create one hidden field. Write this following in its expression
=Iif(Fields!startDate.value =Field!EndDate.value, true, False)

In emp Cell

=IIF(Fields!HdnField.value = true,"red","No Color")

Try this first. If it does not work then I will surely help for writing function.
The above solution is the shortest and easiest way.

Member 9581488 4-Dec-12 13:13pm View

I think for that You have to write custom code(function) to check the conditions for equality of dates and then assign color code for empName cell.

Or else You can have one hidden field and assign true or false based on startdate== enddate. then use the hidden field value to change color of empname cell

Comments by Member 9581488 (Top 170 by date)