Comments by Sibasisjena (Top 150 by date)

@Prashant, please put your code (C# & SQL), that you have tried

Checked your code apart from the report issue, there is a if condition and that will always be executed. Please take necessary action.

if (true)
{

drow["proid"] = "0001";
drow["proname"] = "data2";
drow["cost"] = "200";
drow["code"] = "0123";
drow["shopname"] = "Shop Name";
}

After populating the treeview you can use the TreeNode.CollapseAll Method ()

Do all the table's are having same columns with types?
You are trying to merge those in C# code?

So is it worked?

When you click on the Edit button, the method grdChangeRequirement_RowEditing would be executed. Please check and let me know

You mean, method grdChangeRequirement_RowDataBound is not executed while page load?

The process:
1. On page load the grdChangeRequirement_RowDataBound method would be executed for all rows recursively.
2. Inside this method you need to check the myTextBox.ToString()
3. If the value is "Yes", then only make the edit button disable.
Then it should work. Please post your Gridview markup.

Please check, the soulution is updated. I think you need the RowDataBound event in the grid. Checked your code you have used this one. What is the exact problem you are facing? Your 2nd method should work. Put a debugger in the grdChangeRequirement_RowDataBound event and let me know, whether the control is going there or not.

You have to write code like below:
document.getElementById("yourControlId").focus();

Please send me your .cs file. You can use gett to share files. You can upload the file there. And give me the link. Else you post your code here.

Hi James,
Which control you have used.
1. A list of CheckBox control
2. A CheckedListBox control

i think, onchange of your 3rd dropdown first 2 dropdowns are bound again.

Hi Avinas,

Have you written the codes inside the
if(!IsPostBack)
{

}

Hi Gayathri,

You said correct.

Thanks,
Sibasis

I am not comfortable with vb.net. But i have provided a solution in C# please check my answer below. Please do a null check before use this.

Please provide more information

Do you have firefox browser? If yes, then open this page in firefox. Also open the firebug console and see there what is the issue.

Hi krrazyumesh,

i have added 2 links. Please check those. You can an idea how to get out the issue.
If any specific issue, then please put.

Have you included that js file in your page.

Can you post your c# code

Hi loai_maane,
Please do check in sql server management studio before create dynamic query in c# code. That will help you a lot

Hi loai_maane,

What exactly you are trying to do? You want to add column or what?

Thanks Maciej

Hi Torakami,

How are you binding the dropdownlist. In C#?

Apply style which will satisfy to all the browsers. If not possible then try chrome specific styles.

What is the UI issue, you are facing @vijaykittur

Please explain your question bit more.

Please post your script/ procedure.
Plesae have a look on the below link
http://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row

I would suggest "SCOPE_IDENTITY"

What is the exact error you are getting?

I was in lunch break, i am back to work now. please put your aspx code.

Can you put some more description regarding the problem.

Hi Manohar,
Please try with the below link
http://www.aspsnippets.com/Articles/ASP.Net-AJAX-Control-Toolkit-AutoCompleteExtender-without-using-Web-Services.aspx

Please try this one
http://stackoverflow.com/questions/22223093/how-do-i-add-a-product-specific-facebook-share-button-to-order-confirmation-page

Post your codes

You are most welcome :)

you want a procedure which will insert multiple values into the table.
Am i correct ?

What do you want? you want to create a procedure or what ?
And what is the problem you are facing.

you are most welcome :)

You have used ajax call/server side coding for saving the label value ?

I think, you want paging in your procedure .

convert the enterdate into date time format. check is there any record with the condition you have given in the select statement

Is your control going to showMessage() ?

Can you show me your Jqgrid code.

Get all the strings and concat all the strings separated by comma send it ti Javascript and split there.

ok please check the link, i have provided to you. I have updated my solution.

what kind of Date picker cotrol you are using.

Check the link, let me know this is helpful or not

You want to fetch date from Database and show in date picker. Am i correct ?

Please try the given links, if you will face any problem then reply me.

How do you want to fetch data using Webmethod /Wcf service ?

What have you tried so far ?

What type of grid you are using. I mean jqgrid/some server side grid.

Ok thanks i will check this.

Describe your problem, where you faced problem.

Thanks for guide me.

Where do you want to save the image in database or in folder.

Please look into my solution. If you have any query please ask me.

What have you tried, Please post the codes.

Please check my updated solution.

How can i answer you, Can you please provide the codes.

Please check some links, i have provide to you. If you goal will not be achived then let me know.

Is it your requirement to save in viewstate. Or is it fine if we can add row without using viewstate.

post your codes

Please post your handler code.

I don't know php but is this "session['username']" allwoed in the mysql script

Please delete your existing function, Then run this one.
Please use this one for dropping function
DROP FUNCTION Preg_form9

Can you please give me, what is the error.

Thank you very much :)

Use this one

protected void Button1_Click(object sender, EventArgs e)
{
MailMessage mail = new MailMessage("dnscubes7@gmail.com", "niya4422@gmail.com");
SmtpClient client = new SmtpClient();
client.Port = 25;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Host = "smtp.google.com";
client.Credentials = new System.Net.NetworkCredential("dnscubes7@gmail.com","msquaredrupeshjisha");
mail.Subject = "this is a test email.";
mail.Body = "this is my test email body";
client.Send(mail);
}

Check my updated solution. I have added one more line to solution.
client.Credentials = new System.Net.NetworkCredential("Your EmailID ","password");

You want to go to database again or what ?

If you know how to develop a website. Then you don't have to pay for the development only you have to pay for the hosting in server.

If you are selecting multiple row then you have to for loop. Some thing like this:

For Each itm As ListViewItem In listView1.SelectedItems
If itm.Selected Then
index = itm.Index
End If
Next

You are selecting multiple files at a time or you are selecting multiple files one after another ?

I think you need to convert the date format in your application. No need to do any thing in the Database. In the application where you are assigning the value,there itself you have to convert it.

Can you please tell me what is you column type in the database.

Post your codes.

You can not subtract integer from datetime.

//The follow is not allowed.
DOB - 1

Please describe your question clearly.

Both the methods are doing same thing right ?

Please check my solution @aassaahh

What is your problem?

Please put a debugger in the if condition and upload one file again and check the the control is going inside the if block or not.

This should work because both the pages are in the same level.

Can you please give me the path of the file you want to upload and the path of the saved file.

also post the path of homepage.aspx

path of both the files like
Ex:
C:\Users\sibasisj\Desktop\Admin\admin.aspx

Please give your folder structure of both the aspx pages.

got your problem. The calling page and called page are not in same directory.

I have changed my solution please check it.

Ok got you sir.

If you want to store the video file in your application then check my solution.

Run this script in sql server management studio:
ALTER TABLE [dbo].[FileUploads]
ALTER COLUMN [uname] VARCHAR(MAX)

Check my solution 2

Ok do one thing in the ddlPageRowSize_SelectedIndexChanged event save the selected value in view state. Assign the saved value in the page load again.

Check my solution 4. I have updated it. Your table structure is wrong . The primary key column always will be the Identity(1,1). Please check my solution.

please wait, i will give you a updated sol.

Ok please check my next updated solution

i think you have some problem in retriving the file path

Check my solution. If this will not work then give me your file structure.

Please have a look my solution. If this solution will not work then let me know.

Can you please clear your questions? You want to import the excel sheet into the window application.

please check my answer.

You can change the style in client side.

If we will do this in design view, then the text value will be always 0 according to your above code.

In the page load check the text in empty or null, if yes then assign 0. Remove Text="0" from ASPx page

I do agree with Phil

No need to do any thing. The values will remain same after the post back

Ok got your problem. You need to do an ajax call on the key press in javascript. I mean without reloading the page.

Please explain some more regarding your problem.

What actually you want to do ? I think you want the all records having inserted before today.

Can you please explain some more about your problem.

Please check the comboBoxthana.SelectedText and textBoxLicence_number.Text values are not null before use these. Else check record is there in db for the corresponding values.

If the record is not there, how it will be saved.

You have to do it manually :( .
Declare a variable. use while loop to loop through the records.
Concat all the values you want and then select that concatenated value.

Please like my solution :)

There may be 2 cases
1.The table tblCustomer is not there in dataset
2.There is no table in the dataset

Please check the dataset while debugging and let me know.
Thanks,
Sibasis

First bind the data in grid. Then after i will help you. Please provide your email here.

Ok great, You are most welcome :)

Use the following code and let me know, it is working or not.

using (SqlConnection con = new SqlConnection(str))
{
con.Open();
SqlCommand cmd = new SqlCommand("select Email from Registration where Email='" + loginemail + "' and password='" + loginpassword + "'", con);

using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.HasRows && dr.Read())
{
if (dr.HasRows && dr.Read())
{
Response.Write("Login Successful");
Response.Redirect("Home.aspx");
break;
}
else
{
Response.Write("Wrong user name and password");
}
}

}
}

ok got your problem. It is returning multiple records. I think the problem is due to multi records. Put a debuger and use while loop.

Use the following line

SqlCommand cmd = new SqlCommand("select Email from Registration where Email='" + loginemail + "' and password='" + loginpassword + "'", con);

Run the following script in your DB and tell me the result.

Select * from Registration where Email='jainamit.it@gmail.com' and password='amit'

Can you show me your table structure in DB. I mean what are the columns you have. I will provide you a query. show me by taking screen shot of the data base

There is no record in your database for the particular loginemail and loginpassword

First of all reader is not required.

If the above will not work then go through following links, you may get some idea.
Link1

Link2

Hi Maulikshah,

Can you please post your code. What have you done to achieve this.

Hi Maulikshah,

Actually in makemytrip they have used some kind of jquery controls like JQGRID.
But you are using server side control. If you will fire any event using server side control then the whole page will load again.
If you want to load the particular grid, then go for a JQgrid.

Thanks,
Sibasis

I agree with you @Karthik

Can you please explain some more about your problem. I am not getting what is your problem.

What is your question @ak.prakash

It can be possible using server side as well as clientside(javascript). First confirm what do You want ?

Can you please check the class or id of that label after rendering ?

Hi djrocks, did you get your answer or anythingelse you want.

Hi kelly, you can do this functionality by using Jquery or in .cs page. First decide in using what you want to do that. If you will do it in jquery .cs code is not required vice versa.

Please provide more data to solve your problem.

Hi bahar_Agi,
write the javascript coding in <head></head>.
It is better and the proper way.

No you can not check a mailId is valid. If you want to do this the send a mail if you got response then that emailId is valid one.

Actualy we can not hide text.We can do one thing the text which you want to hide.Just hide the container of the text.

Linq is better than sql because linq has more advantages than sql

it is another way i have written above