Comments by Azee (Top 123 by date)

Great, cheers.

You can use CommandArgument or CommandName's value to identify which TextBox was changed. I have shown you how to get those values. What is the problem now?
and What is the parent control of these TextBoxes?

Can you post the content of your GridView as well?

What is the error that system shows?

Please post the relevant code.

Post the relevant code where you are experiencing the problem.

How are you selecting the ListView rows? CheckBoxes?

good, mark as solved. :)

:)

mark as solution :)

A little description of problem would be helpful.

check the path for web service, is it ok? and where is the web service in your own project?

What do you need it for?

As you can see, what I did in first Select statement is not generic, its specifically for 4 items, if you do it for more items the conditions in the where clause will increase by many.

Let me see what I can do.

Sorry I missed the C# part, I have added a basic code for this operation, and converted the script to a stored procedure.

Add Drop Table #TempTable at the start of the script .. remove it when you use it in a stored procedure

which one is it? :)

Does table_Items_Shelves already contains records? and you want to update against those records?
Or you want to insert new records from table_items?

what value does TextBoxSchool.Text return?

Hey there, one idea would be to combine Name and Item with another character in the middle and use it as one key, for example, "Store1$Beans" as key.

Have you configured the GridView to show two columns?

Is there a possibility that you are using the sqlParams more than 1 for multiple commands?

Which line throws the Exception?

Hey there, put a break point on LoadCommunicationGrid method and see which line throws the exception.

Windows? Asp.net? mention the framework please

Didn't you try binding those Values against the Texts with the ComboBox and try SelectedValue to get the Values?

in this line, this Exception could occur if row.RowIndex does not lie within the indexes of the GridView Rows, and since its in a loop, this should not be a problem.
what is row.RowIndex when you debug?

That is the problem. docid '0', I am sure there is no docid in DocumentInfo table with value 0. Why are you getting values from Session for docc.approve? when did you store them there?

By the way, your code doesn't make much sense, you are trying to call the same SP twice with different values using docc.approve and rest of the code.

Take a closer look, that is the only reason this Exception could occur, where exactly the Exception is occuring, here:
docc.approve(Convert.ToInt32(Session["UserID"]), Convert.ToInt32(Session["DocID"]), Convert.ToInt32(Session["ApproveID"]), Convert.ToString(Session["Login2"]));
or here:
cmd.ExecuteNonQuery(); ?

Debug and check the value of DocID that you are trying to insert in Approval table, it should be present in Primary key values of DocumentInfo table.

Is there any specific part of Submit operation that is causing an issue? be more specific please.

Just the formatting, nothing to worry :)

Hey there, I don't see sNO, Name or Contact being saved in the ViewState, there is BatchNo, Quantity and SelectedQuantity.

Can you post your Store Procedure as well?

SQL SERVER, MYSQL? what are you using and please specific the functions that you tried.

I am a little confused, do you want you TextBoxes to have values with Decimal or without?

Could you all post aspx side of the code (TextBoxes) in your question?

Please post the code that you have tried to insert data in database.

So you mean, that there are multiple entries in table of a specific food name?

IE supports a Microsoft-only property alpha filter. Alpha filters in IE accept values from 0 (completely transparent) to 100 (completely opaque). So, to get your transparency in IE, you should multiply your opacity by 100 and add an alpha filter to your styles

So you want your SP to return just the full name concatenated? You don't need an SP for that, just create a function and return concatenated full name.

I mean, post the Buttons of aspx page and the JavaScript function implementation.

Can you please add Button's code and JavaScript function as well in your Question?

This code:
if (Session["UserID"] != null)
{
//Store the value into a variable
int userId = Convert.ToInt32(Session["UserID"]); //you could also use Convert.ToInt32(Session["UserID"]);
}
gets UserID from Session.
You need to save UserID to session before you can get from it.

Where? I don't see it
The UserID is supposed to be the ID of the user who logged in, so according to my understanding, you should get UserID when you verify User Name and Password, and according to your code, this line should return the UserID of the verified User:
int users = aa.SignIn(txt_username.Value, txt_pass.Value);, isn't it?

In all your code, there isn't one line that SAVES UserID in Session, Do have any code where you are doing this:

Session["UserID"] = SomeValue?

Please add code of upload operation in your question.

If you can get the userid from Session on Upload.aspx, then what is the problem now?

Hey there, user is just being logged in in your Btn_login_Click, then how are you getting an ID from the Session: user_id = Convert.ToInt32(Session["UserID"].ToString());?

You have already passed @transno alone in the second scipt, and have tried passing @tranname in the first one, what exactly do you want to do with these paramters. what will you compare @transname with? any table column's value?

Hey there, have you checked your Table data, may be there are duplicate records, e.g, for Firstname and Surname,
check and let me know, if there are, I'll let you know how to avoid the duplicates

Any progress that you have made so far?

hey there, what is the DataType of column txtDate, Date or DateTime?

I mean what is the exact datetime string that dgr.Cells[2].Value returning?

What value does this part return,
dgr.Cells[2].Value?

Hey there, Do you mean, you are redirecting to another page, multiple times an each time adding a row, but losing the previous ones?

Please verify your link.

So you want to calculate child nodes of the parent?

What have you done so far? post your effort we'll take a look.

So according to the table, 1 has 2 and 3 attached to its left and right. not 4

Hey, dont remove the while loop, just move the email code:
int quantity = var;
if (quantity < 5)
{


MailMessage mailObj = new MailMessage(
"from", "to", "product low quantity",pro);

SmtpClient SMTPServer = new SmtpClient("localhost");
try
{
SMTPServer.UseDefaultCredentials = false;
SMTPServer.Host = "smtp.gmail.com";
SMTPServer.Port = 587;
SMTPServer.Credentials = new NetworkCredential("email", "password");
SMTPServer.EnableSsl = true;
SMTPServer.Send(mailObj);
}
catch (Exception ex)
{
// Label1.Text = ex.ToString();
}
}
Inside the loop.

and keep these two lines outside the loop.
read.Close();
con.Close();

Give an example of the output you are expecting after combining page23.aspx?cat=shoes with navigateURL and please specify what does "area" field return?

Not clear man, you have got the query, what is the problem?

how is 4 related to 1 in your first example?
Sorry it seems a little confusing.

Great, cheers :)

Could you please post your code as well?

Could you please specify the actual content of the logo field?

do you want to check quantity for each row of listview?

where did you write the above code? and lblHrs is not in your footer template.

Can you post the code and css?

Try to set the min-height of the container in which the this perticular Content is placed inside master page.

Please debug your code and find the line where this exception is occurring.

Use it when you need the UserID to insert in the documents table. Get the UserID as stated above and pass it to the procedure that is inserting document records.

Note: I used long, because I supposed UserID DataType is Bigint, if its Int then you can use Int here as well.

You should be able to see the problem. Anyway, do you have access to the server where the application is deployed? If you browse on the server locally, then instead of this page you should be able to see the real error.

Hey there,

The server display this error when there is some kind of problem (either an exception on the page or configuration issue)

and when you set customerrors mode="Off" and browse instead of above content it displays the actual problem that is causing the application to not work.

You should be able to see the actual problem now.
What does the page display when you set customError mode="Off"?

Can you please post the code as well?

Can please you post your code as well?

Post your code please.

Great, cheers :)

there are two question in my above comment, please answer the first one.

You have droplistcolumn and you are bind the values in your code,
does the selection of the DropDownList's values is based on data from dtCurrentTable?
that you are binding to the ListView? and which DropDown is it ddldatatype or ddlexamples

what error does this line return,
objBusinessUI.StockDate =Convert.ToDateTime(((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim());
You said runtime error?

You are binding the ListView in your AddRow method,
listview1.DataSource = dtCurrentTable;
listview1.DataBind();

It will reset all data inside the ListView, hence reseting the DropDownLists.

Do you want to keep the state of that dropdownlist?

Is the DropDownList that is clearing, inside the ListView?

Could you post your code where you delete the row?

When you debug, what value does this line return
((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text ?

Do you have to add the UserControl dynamically? In this case code inside If(!Ispostback) will never get executed since your above code is executed afterwards.

Please clear, do you want to get the days where the value is 'absent' or select only that column where value is 'absent'?

hey, on mouse click your image button will get a postback, so any javascript will not affect. do you want to keep button_yellow.jpg image after the postback or when user just presses the click button??

Could you explain the term Sub Categories? and how would you wanna use them?

Can you please post your blur event code and TextBox?

Whoever down voted the solution, would you care providing a reason for that?

Its good to want things :), what have you tried so far, Rahul?

Hey Faizan, what is the datatype of hadith_eng_book Column in your table?

Sorry, I couldn't understand your question. Check the example below.

Hey, I am asking why do you need to do that when you can do sorting in the query? Give me a good reason then I'll suggest a solution.

So you are saying you want to change the order by which the rows are saved in the database table? and why does that even matter when you can order them anyway you want in your queries?

By " order those row by my needs" do you mean in a Select statement?

What are you referring to? Use what? Can you access the resource file by name?

You mean a property that you could access from aspx page where you might use the Control?

What is the data structure that contains those numbers?

Please post your stored procedure where you want to apply the above statements.

You wrote you are getting any error in Select, what is that specific error.
Post you MyCar table structure.

What error are you getting?

here I think this'll do:
Declare @CustomerId int = 1;
Select distinct PM.ProdModelId, PM.ProdMasId, PM.ProdModName, @CustomerId as CustomerId ,
Case when SD.SalesId IS NULL THEN 'false' ELSE 'true' END AS Purchased
from ProductModel PM
Left Join SalesDetails SD on PM.ProdModelId = SD.ProdModelId
Left Join SalesMaster SM on SD.SalesID = SM.SalesID and SM.CustomerID = @CustomerId

What have you tried? a little demonstration might get you a help quick.

Ok, from your code in the second page, I get that you are trying to insert a record in the database using that QueryString and the TextBox value in the Button event. First thing I don't understand is why you are using Page.FindControl to get the TextBox, if its on your page you should be able to use it with just its ID.

Anyway you should move the code to get querystring from Page_Load to your Button's click event because that's where it'll be used.
That's it, I don't see anything else wrong with code. If you find one, try debugging.

Are you sure this is the output that you expect based on the data in the tables? I strongly suggest you to recheck.
What I understood is that you want details of ProductModels, whether they have been purchased by a Customer or not and if yes then the ID of the Customer.
So, in your case 'nokia 6300' have been purchased by two customers so there should be two records for this model in your output and since 'Samsung Note' haven't been purchased by anyone there isn't supposed to be a CustomerId against this record in your Output. Please verify.

I replicated your scenario and the JavaScript function does get called. There could be something wrong in your function. Debug your JavaScript function. Try alerts from line to line. If its not your function that post your complete code. I'll take a look.

Could you please specify the possible output that you would expect from the stored procedure?

if you need specific solution, please post your code that you tried.

Yes that would be better, please do.

Could you leave the code and actual name of the Page in which you have the User Control. I produced the scenario and its working for me. In my scenario if MyPageName is name of your page and the User Control is placed inside this page then it should work.

Is your TextBox inside another Server control e.g. Repeater etc?