Comments by Ashi0891 - CodeProject

Ashi0891 8-Sep-14 12:12pm View

where is the problem? You havnt worked with pop ups in asp.net so far? or what?

Ashi0891 8-Sep-14 12:10pm View

"Example if i wanted to retrieve Nelsons data but only know his username."
you can use 'where' clause in somewhat following way
where fullname like '%'+@name+'%';
myCommand.Parameters.AddWithValue("@name", 'mandela');

this will help you get data for person having name containing 'mandela'. it will work only if data contains first name and last name and no last name would be first name for any person.
hope this helps.

Ashi0891 8-Sep-14 11:56am View

You are doing same operation on both listbox.

Ashi0891 2-Sep-14 6:50am View

haha.. well said.

Ashi0891 1-Sep-14 14:26pm View

I guess you should better use it like
where ...... AND (name='' OR name=@parameter); and this should work.

Ashi0891 1-Sep-14 14:25pm View

Deleted

I guess you should better use it like
where ...... AND (name='' OR name=@parameter); and this should work.

Ashi0891 1-Sep-14 14:17pm View

+5. and karthikeyan9966 it was a simple error kid. try checking your code nicely before posting.

Ashi0891 1-Sep-14 14:15pm View

I havn't read all your code so don't know what you are up to but
oki.isy(a,b,name.Text,address.Text);
is taking four arguments whereas
public int isy(proinsert.insert ayo, out string stadre)
is taking only two arguments. try to solve it now.

Ashi0891 29-Aug-14 2:32am View

Perfect solution.

Ashi0891 28-Aug-14 12:38pm View

What is the problem?

Ashi0891 27-Aug-14 13:15pm View

Can you explain a little more. I didn't really get "Hello I need help listview1 displays the contents of the table Youtube but if the table viewed are the same values, they will not be visible to the logged user where his id is ListView2.Items(0).SubItems(0).Text but will be visible to other users.". how to do "what"?

Ashi0891 27-Aug-14 13:11pm View

I don't know visual basic but I think you should bind your repeater in code behind. and then call it on button click and in IsPostBack rather than giving it in aspx code using sql datasource.

Ashi0891 27-Aug-14 12:57pm View

Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "'" ;

Is this code statement giving you any error?

Ashi0891 27-Aug-14 12:39pm View

You should have better added this code in your question rather than putting it in comments, as unformatted code, using Improve question option.

Ashi0891 27-Aug-14 12:37pm View

Yeah one needs to check for null or existance of querystring parameter. Make sure UserName querystring parameter has some value before passing it. +5

Ashi0891 27-Aug-14 12:26pm View

search web for displaying data in html tables.

Ashi0891 27-Aug-14 4:02am View

thank you. your solution helped me to code my problem. I have posted solution3 as my used code. :)

Ashi0891 27-Aug-14 3:59am View

no sir this is simply a repeater control and its databind. My question is entirely something else. anyways, i have solved my problem as in solution3.

Ashi0891 26-Aug-14 10:50am View

how is this splitting fields from one column?

Ashi0891 26-Aug-14 7:08am View

yes sir

Ashi0891 26-Aug-14 4:48am View

thanks for suggesting. I will try using a repeater. please help me with "How can I abstract single field from the column? and show it in a label." part as well.

Ashi0891 26-Aug-14 3:32am View

then post this solution and mark it as Answer.

Ashi0891 26-Aug-14 1:07am View

please mark one of the solution as answer so that people around here know that the question is solved.

Ashi0891 25-Aug-14 6:23am View

where is the problem? while storing image in database or in sending mail?

Ashi0891 25-Aug-14 4:46am View

nice link!

Ashi0891 25-Aug-14 2:11am View

You can use something like this may be
if(checkbox1.selectedindex==1)
{
do something
}

Ashi0891 25-Aug-14 1:52am View

https://www.google.com/search?newwindow=1&site=&source=hp&q=how+to+get+duration+of+audio+file+in+asp.net&oq=how+to+get+duration+of+audio+file+in+as&gs_l=hp.3.0.33i21.324.11042.0.12481.39.27.3.7.8.1.290.3784.0j20j1.21.0....0...1c.1.52.hp..10.29.3387.0.10kNhwkQBZQ

Ashi0891 22-Aug-14 9:51am View

Please paste your connection string. I have gone through this error sometimes.

Ashi0891 22-Aug-14 8:23am View

please you elaborate "how to bind it to textbox with calendar tool in asp.net tool ?" this part of your comment.

Ashi0891 22-Aug-14 7:20am View

even this doesnt work for me.

Ashi0891 22-Aug-14 7:09am View

https://www.google.com/search?newwindow=1&site=&source=hp&q=freeze+datagridview+columns+using+css&oq=freeze+datagridview+columns+using+css&gs_l=hp.3..0i22i30.852.9697.0.9915.37.31.0.3.3.0.268.4537.0j18j6.24.0....0...1c.1.51.hp..13.24.3983.fFiliQxL5NM
You should have visited this link before posting this question.

Ashi0891 22-Aug-14 3:55am View

good option!! +5 :)

Ashi0891 22-Aug-14 3:50am View

use sessions or pass that value using querystring while redirecting to second web page.
Search on google about these ways, in case you have any problem after that then let us know.

Ashi0891 22-Aug-14 3:48am View

can you use text box text changed event?

Ashi0891 22-Aug-14 3:42am View

What is the role of "TextBox" in "Insert Update Edit Delete record in GridView using Javascript in ASP.Net" part?
and in case you are looking for two solutions, one for searching gridview data using textbox and other for undergoing sql operations on gridview using javascript then please be more specific. Also tell what have you tried till now.
I have also posted a solution1 please check it out.

Ashi0891 22-Aug-14 3:40am View

this code works for me, may be you are not getting your required result. Please Use improve question option to explain more and also add your desired output.

Ashi0891 22-Aug-14 1:34am View

your title is different than your question. Please use Improve question option to explain your question as per your title.

Ashi0891 22-Aug-14 1:27am View

you want one dropdownlist to be "hard coded" and others to be filled as per gridview data? is it so?

Ashi0891 21-Aug-14 13:59pm View

have you provided the connection string? I don't think so!
and later add "sqlconn.open();" before "sqlcmd.ExecuteNonQuery();" or before try{}, and also add
finally
{
sqlconn.close();
}
after catch{}

or simply do as Solution 2.

Ashi0891 21-Aug-14 2:43am View

Have you done something similar to this ever? I can help by providing code for this in website application asp.net c#. Will you be able to apply it in your project with few changes?

Ashi0891 20-Aug-14 14:13pm View

Try removing "~/" while saving the file in the folder.
Therefore it should be- fileuploader1.saveas(server.mappath("userimage/"+fileupload1.filename));

Ashi0891 20-Aug-14 7:30am View

do you mean delete account/registration with "disable"?

Ashi0891 20-Aug-14 7:26am View

what do you mean by "the selected item will displayed as a row in the grid view"? Dropdownlist has only one value. and gridview row can have many columns. Do you mean you want to show data from database according to dropdownlist selected item? If so try searching it on google. You will get it easily.

Ashi0891 20-Aug-14 6:56am View

Ashi0891 20-Aug-14 5:32am View

Sergey Alexandrovich Kryukov said it right. But still if in case you want to use jquery then Do a favour, type "fill gridview using jquery in asp net" in Google search and try helping yourself.

Ashi0891 20-Aug-14 5:28am View

From what i could get, you want to add selected data from dropdownlist into database to respective entry. And at the time when you show the data you want to show all the items of dropdownlist and the one which was selected and is added in the table data should be selected or be highlighted. Is it so?

Ashi0891 20-Aug-14 5:11am View

where is the problem?

Ashi0891 20-Aug-14 4:51am View

lemme try to understand you want to save the selected drop downlist item into database for respective entry?

Ashi0891 20-Aug-14 4:45am View

check the query again. make sure you have correct table name and column name in your sql query. other than that try giving some value to uid that exists in the table and try to execute it in sqlserver itself.

Ashi0891 19-Aug-14 12:43pm View

M sorry. I'm new here. So Dnt really know about the rules. I'll make sure of this in future.

Ashi0891 19-Aug-14 9:40am View

Please mark it as answer if you got the required result :)

Ashi0891 19-Aug-14 8:59am View

Show your aspx code as well.

Ashi0891 19-Aug-14 8:11am View

Sorry for that check solution2 please.

Ashi0891 19-Aug-14 7:40am View

what do you want to do when you link listbox with other controls? I'm afraid I still didnt get you well. Explain it with output example if possible.

Ashi0891 19-Aug-14 7:34am View

what have you tried yourself? Did you google it? even if you just copy paste your title in google search engine you will get exact answers and similar posts on codeproject.com itself. Please try to solve your problem on your own before pasting it here!!

Ashi0891 19-Aug-14 7:17am View

what do you mean by "I need help on link listbox with textbox,checkbox,combobox on a database."?

Ashi0891 19-Aug-14 7:03am View

You are welcome :D

Ashi0891 19-Aug-14 6:48am View

It states "bool int.TryParse(string s,out int result)".
Which means TryParse returns bool value so I have used if statement.
And it takes two arguements one is string and other is int("out" is used to give the result in that "int" variable) which should be defined before used in this statement.
For more reference check the below link:
http://msdn.microsoft.com/en-us/library/bb397679.aspx

Happy Coding :)

Ashi0891 19-Aug-14 5:07am View

hey I am still not getting my required result. It doesnt show anything in cityid. Its empty.

Ashi0891 19-Aug-14 2:21am View

Deleted

try replacing your code with the following:
cmd.Parameters.AddWithValue("@a", UserName);
cmd.Parameters.AddWithValue("@b", countryId);
cmd.Parameters.AddWithValue("@c", IsActive);
cmd.ExecuteNonQuery();

Bcoz you used @a,@b,@c not just a,b,c. And cmd.ExecuteNonQuery can not to assigned to int. Basically I does not return anything. In case,if the execution of "cmd" returns it is when you give "Select" Command. And also we use datareader in that case.
Hope it Works for you :)

Ashi0891 19-Aug-14 2:01am View

Its RDLC not RDCL. Right?

Ashi0891 19-Aug-14 1:44am View

On what basis from table1 you want to modify data in table2?

Ashi0891 19-Aug-14 1:02am View

Please mark it as Solution if it worked for you. So that people here can know the question is solved.

Ashi0891 19-Aug-14 0:49am View

try removing the statement "cmd.ExecuteNonQuery();"

Ashi0891 19-Aug-14 0:45am View

I have added my code please have a look.

Ashi0891 18-Aug-14 8:07am View

It wasnt my question. Though your solution can be the answer but I think if the closing tags were missing it would have given error at first place.

Ashi0891 18-Aug-14 7:59am View

Bingo!!

Ashi0891 18-Aug-14 7:50am View

What i could get from your statements is that you want to give a file(like word or pdf file) and you want that the database will get the data from that file and store into the table on its own.. Am I right?
Bcoz if you simply want to add a file into the database then you can easily get the solution from "Google".

Ashi0891 18-Aug-14 7:22am View

where do you have your data? in Gridview control of asp.net?

Ashi0891 17-Aug-14 4:46am View

Thumbs up!!

Ashi0891 17-Aug-14 4:41am View

What is the exact line of code that you didn't get. Specify it and let us know how much did you get on your own.

Ashi0891 17-Aug-14 4:36am View

But why do you have repetition of data? Do you mean you Dnt want to insert last two entries from this example? In othe words you want to insert only one row with October month from above data?

Ashi0891 17-Aug-14 0:14am View

Though the above answer is very correct, in case you want to give different alert message on different control then you can put the code inside DropDownList_SelectedIndexChanged event of every dropdownlist.

Ashi0891 16-Aug-14 14:40pm View

have you ever heard about "Google"? Atleast give it one try!!

Ashi0891 16-Aug-14 13:03pm View

Please explain more and don't use question as a title. Try to keep it brief.

Ashi0891 16-Aug-14 13:01pm View

you can increment a variable in for each loop.

Ashi0891 16-Aug-14 12:44pm View

can you explain a little more?

Ashi0891 16-Aug-14 12:29pm View

Where and what is the problem?

Ashi0891 15-Aug-14 6:13am View

it is not if(dr.read()) - we dnt check for condition here
its while(dr.read()) - we do the following "while" the reader is reading.

Ashi0891 15-Aug-14 5:47am View

http://www.codeproject.com/Articles/259376/Using-AJAX-AutoCompleteExtender-for-autosuggest

it says "the “count” refers to the maximum number of records in the auto suggest" :)

Ashi0891 15-Aug-14 5:40am View

Deleted

the “count” refers to the maximum number of records in the auto suggest :)

Ashi0891 15-Aug-14 5:21am View

ofcourse it doesn't. You are getting *(all coumns) from database and showing it in one textbox, and you think it will work?
secondly.. you dnt get value from reader this way. please check my solution.

Ashi0891 14-Aug-14 10:00am View

Well done.

Ashi0891 14-Aug-14 9:57am View

You are getting this error when you upload it?

Ashi0891 14-Aug-14 7:57am View

You question is completely incomplete.

Ashi0891 14-Aug-14 7:03am View

check for column names and number of columns in your table and also the order of columns that you are providing.
also you used @confirmmail in query and @ConfirmMail while passing parameters. it is case sensitive please use any one and only one of them at both places.
of all try executing this query in sql server database.
until and unless we dnt know abt your database and the table structure we cant answer such questions. try to explain what you post dnt simply copy paste your code here.

Ashi0891 14-Aug-14 6:44am View

what have you tried till now? n what is the exact problem you faced? did you mean you want to save upload file name in file uploader even after post back?

Ashi0891 14-Aug-14 5:58am View

what have you tried?

Ashi0891 14-Aug-14 5:43am View

let me try to understand your question. you have a listbox which contain values vertically(obviously) and then you show those values in label with commas separating them.
now you want a stored procedure example which will insert data from label to database and select and show data from database in listview. am i right?

Ashi0891 14-Aug-14 5:04am View

sorry I got busy with my other projects. Thank you for your solution.

replacing var _cityId = $('#<%= ComboBox1.ClientID %>').val();
with var _cityId = $("<%= ComboBox1.ClientID %>").val();
in your given code, solved my problem :)

Ashi0891 14-Aug-14 2:15am View

what are you actually trying to do here?
and why are you doing it this way?

Ashi0891 14-Aug-14 2:05am View

good and easy :)

Ashi0891 12-Aug-14 13:45pm View

True that.

Ashi0891 11-Aug-14 8:01am View

I am afraid it didnt help me any :(

Ashi0891 11-Aug-14 6:24am View

this didnt help

Ashi0891 11-Aug-14 6:05am View

it still gives the same error

Ashi0891 11-Aug-14 6:00am View

similar post http://stackoverflow.com/questions/18458697/how-to-display-the-logo-on-the-address-bar

Ashi0891 11-Aug-14 5:58am View

did you search on google?

Ashi0891 11-Aug-14 5:52am View

The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).

i am getting this error.

Ashi0891 11-Aug-14 5:46am View

what are you actually looking for? doesn't the save button works here same as other save buttons?

Ashi0891 11-Aug-14 5:26am View

the actual code contains many others controls. so i have pasted the one which is related to the issue. please take a look.

Ashi0891 11-Aug-14 5:13am View

it isnt working for me. and also i would prefer to use than <span>

Ashi0891 11-Aug-14 4:26am View

not on page load. its when we click on image or label i.e. when we click on any control inside tag.

Ashi0891 11-Aug-14 3:48am View

can you post the code that will form in my case if i use this?

Ashi0891 7-Aug-14 4:08am View

adding TotalNumberAdded=0; in button2_click event code resolved the problem. thank you so much!

Ashi0891 7-Aug-14 4:02am View

I have Updated my question please have a look

Ashi0891 7-Aug-14 3:41am View

Deleted

I have updated my question please have a look.

Ashi0891 7-Aug-14 3:40am View

i have pasted all the code.. please take a look.

Ashi0891 7-Aug-14 3:33am View

I have already gone through this form and many other that i searched from google. i have added my code to the question. please take a look.

Ashi0891 6-Aug-14 5:01am View

that's it? It worked.
oh i wish i had used a lil bit more time to make it work on my own.
Thank you so much!! :)

Comments by Ashi0891 (Top 110 by date)