Comments by PrashantSonewane (Top 72 by date)

I understand your requirement. Delivering it cost you $50(Excluding tax)...

Murali, Don't tell us requirement, tell us whats the problem you are facing working on this so that we can help you..

Check your connection string if its correct once.

Add some code you have tried and stuck.

Why you need C# program for that? Ofcourse every SQL server have username and password (windows or SQL). If you don't know, you should be asking to admin / authority.

Can you find out what code is causing this error and add that code. It will help us to understand whats going wrong?

1. You want total to be 100. So why you are checking sum !=100. You should be always checking sum <100.
2. Have you tried using JavaScript or Jquery as you are using ASP.NET. That's better approach for doing all validation before calling save method.
3. Using same javascript function you can manage visiblity of textboxes.
Let us know if you stuck trying out Javascript or jquery.

I do.. But i would suggest you to go on MSDN and get step by step info about webparts. There you will get sample , code and screenshots as well... It will be lengthy.. but as a student it should be ok for you..
Follow: http://msdn.microsoft.com/en-us/library/e0s9t4ck(v=vs.100).aspx

Humm... I had never done my own presentations too.... ;)

A wild guess.. Check the web.config file for something like "sessionstate mode="InProc" cookieless="UseUri". If you find this, that means the website is configured not to share the same session in two tab in same browser (like IE8). In this case, you will see such junk ids attached in the URL... Again.. this is just a guess...

you want to shape html editor or content in html editor?

Can you give some code of your html file where reg. expression is?

check the server name in your connection string. Either connection string contains server name different than it should be (may be typo) or server is not running (check sqlserver processes).

If everything looks good, verify if sql server allows remote connection. Try this link.. may help

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

What kind of application? Windows or Web? Try using regex and let us know if have any issue.

"if we delete any row from the table then it should serialize the number " means? some details please. Example would be good..

Please give some code how you are trying and more details about problem you are facing.

thanks :)

Check the request for this page have querystring named MessageNumber. Your request url should have something like this http://yoururl/default.aspx?MessageNumber=somenumber. Also make sure you are not making spelling mistakes while typing it.

revisite my code again. It will only make 0.00 if the value in textbox is blank. And thats what the request was.

add code of html of your page, which may help us understanding whats going wrong.

And you are sure that is inside the <form> tag. Please check once. There shouldn't be any reason why lable is not accessible.

You can do it multiple way. Like maintaining id in code side and passing it with every proc call. But if you are using SQLserver 2008, try using table value type to push whole list as param and insert into one go with one id. You need to learn more about how to use table value type, but i think its worthy.

where is your asp:Lable in given HTML code? I am not seeing it. Make sure you have that inside the <form> tag. Code behind will find it anyway.

by the way.. i just found something for you:

Lists, Libraries and Pages

You could have spent same time to search on net directly than posting question here :)

Hope you have that control with-in <form> tag. Check once...

what is the error?

mark original post as solution. This may help others as well.

replacing this code with your for loop code is not working? Whats the issue.. you can debug and correct it..

this may help

http://codingatlas.wordpress.com/2006/07/08/darken-the-page-and-set-focus-on-the-user-input/

can you help us understanding why you need empty record in table? I believe you are keeping this empty record to avoid null error. If so you can handle null issue properly and delete all records. However if you still want to have empty record then you should write condition in delete commandstring something like "Delete from StudentDetails where Student_code<>'' and Student_desc <> '' and Student_telno<>''

Hope this helps

try something like this

DataRow dr = (DataRow)e.Row.DataItem;
if (dr["language"].ToString() == "H")
e.Row.CssClass = "NewFont1";
else
e.Row.CssClass = "FontEnglish";

DataTable cab = (DataTable)Session["tab"];

for (int i = 0; i < cab.Rows.Count; i++)
{



if (cab.Rows[i]["language"].ToString() == "H")
e.Row.CssClass = "NewFont1";
else
e.Row.CssClass = "FontEnglish";

}


You have to work on this part. You are looping through datatable's rows and expect gridview row css change. Where you are checking the datatable's rowindex is matching with current gridview row index? So all rows in gridview will get datatable's last row condition satisfied and hence only once css will be applied for all rows.

can u pests your css class code.

sorry.. my bad.. i was thinking other way...

Have you tried something? Can you give code block you have tried and tell us whats not working?

you are aleady adding the values in SQLCommand. You dont need to pass any parameter values. Remove the code of adding param and param1. It should work..

Add your code here so far you have tried..

Add your code here to help us where is the problem...

if(DropDownList1.Items.FindByText(dr["FiledName"].ToString())!=null)
{
DropDownList1.ClearSelection();
DropDownList1.Items.FindByText(dr["FiledName"].ToString()).Selected = true;

}

can you give the html code, which may help us understand better whats going wrong?
Meanwhile you can check if validation group is set correctly and no other javascript function is being called which return false. Also check autopostback property (should set to true) for the controls you want to fire event.

add your code you are trying if possible to get more idea...

Where did you stuck? Can you give problem details? you can put your code as well.

Please add more details like what is the requirment / implementation, what is the problem and what is expected. Can't make out anything...:(

Is this javascript function or C# code? little confused when you said code behind. If your code is at code behind, best way is to assing string.Empty (or '' in case of javascript). And while saving you can check if textwishlistsong1.text / value == string.Empty or '' then insert or send null.

can you add code how are you doing it now?

instead of appenddatabounditem have you tried inserting "-Select-" like below:

DropDownList1.Items.Insert(0, "-Select-");

Choice would be depend on what type of data you are binding. Without looking at that, hard to make decision. Generally we should use collection if data is volatile and stored in database.

Making default is dropdownlists property and not of enum. you can use dropdownlist.items[0].selected=true property by selecting any item of choice.

Thats the implementation choice. However if collection is known and static ( we are sure that gender collection will have these static entries), should go with enum. No need to add database calls and other impplementation. Reduce db call as much as possible. Make sense?

Are you getting any error?

Is textbox on ASP .NET page or winform? If on ASP page then use javascript function (with regular expression or reading keycode). In Winform you can check the keycode on textchange event.

Mark as Solution if this work for you.

Also replace <write here="" student="" id=""> with actual student id like cr.stud_id = 100 or whatever value is. Hope this help

camma were missing, i added there. try again. I do not compile code as i don't have tables created.

use something like this:

string str = DataGrid1.Column(X).Value;

str.Replace("\\Library\\","");
string[] lstImage = str.Split(',');
string img1 = lstImage[0].ToString();
string img2 = lstImage[1].ToString();
string img3 = lstImage[2].ToString();
string img4 = lstImage[3].ToString();
string img5 = lstImage[4].ToString();
string img6 = lstImage[5].ToString();

However \ will give you some trouble working with in C# as it is escape char. Check on that.

Please explain the situation with more details / code and issue description.

can you try
DateTime dt = DateDateTime.Parse(tbJoindate.Text);

myCommand.Parameters.Add("@Joindate", System.Data.SqlDbType.DateTime).Value = dt;

Have you tried the proc i gave above? just copy whole stuff and execute once and test the proc (as give below). Its saving that in rows.

How you are inserting data in other server? using linked server or connectionstring for source and destination db in windows service? If linked server, then you can use stored proc and check if data already exists. If connection string, then write stored proc in destination to check if data/record already exists and skip is yes.

Mark as answered if this work for you!

Make sure you have more than 10 records while testing. :)
Try setting pagination properties in page load. However it is as good as setting at design time. Pagination will show the pages if number of records exceed than 10. I don't think you need to change the pagination property. Number of Rows you can change dynamically.

Mark as answered if it works for you...

OK. I assume that you have upload and delete button in page and checkbox in repeater control in page. Whenever you upload anything, repeater gets new row. Now if you select few/one checkbox in repeater then you want to make Delete button visible. If this is correct, then write simple javascript function to turn delete button visible on or off. and call that function on onClick event of checkbox.

Its not related to Interop exel. I was check checking if your OS is server and 64 bit. If it is 64 bit, there is another folder for system files SysWOW64 unlike 32 bit. Hence you need to create Desktop folder both the places. Bit here is not related to Excel interop but with OS. Anyway yours is 32 bit. Will reply if find breakthrough or clue.

check if autopostback is true.
chk.AutoPostBack = true;

Can you access class without submitting the page? Where you are calling the class method? in HTML of page or java script function? You need to submit the page and hence get the value first to page and then pass it to class.