Comments by ShivKrSingh (Top 38 by date)

I'm using excel file in my application and want to check if someone enter text in ID field it should be validate. but when we read it text is not displaying if it is not in number format. While value exist in excel file. if I format that column as text in excel sheet it goes well. But this file generate at runtime and destroy. so I want a solution that can help me conversion. without any manual change in excel file.

don't forget to mark it as answered if it solved your problem

I know this but he doesn't have any relation and want output as he displays this can solve his problem. but he should need to rectify his database to do this. Till that time he can use this.

hi, In your code it is used to download existing file. but I want to save it only if there is any modification take place in data.

This is windows application and I have integrated excel file in webBrowser control because I searched lot but not found any other solution. I also want full control over Excel file. I want to check if data modification take place it should save in existing file. If you have other way to use excel file in application, please do let me know....

This function doesn't do any thing with outerHTML.

this may give you overflow error. because it you may not have idea of full number range. It can be greater then the size of int32 like your example 123456789,0123 and you want to convert it 1234567890123 this number is greater then Int32 range. You should confirm your digits before changing it into Int32. It is better to use Number(Max digit you want before decimal, decimal places) in sql server and use double in front end. you can use round off if you want in this Case. but not in your condition.

Your Question is not clear. Please provide more details. You can use "order by NewID()" in your query to get question randomly from database.

you can track space for doing this. when system find space and replace that space with (,) comma.

you can do one thing that take one button and make its visible hide. and on click of this open this popup like

in page load
if(!isPostback)
{
btnName_Click(sender, e);
}
so this code will make is click only first time. on after this even after Post back. It will only show when you are visiting your page first time. One More thing if you will Manually Refresh page that will act as it is loading first time. so it will show popup again but not after it. Hope this will fulfill your requirement.

Control cont;
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdnURL.Value))
{
cont = LoadControl(hdnURL.Value);
}

MasterList1.btnClicked += new HR.Controls.Master.MasterList.onLinkButtonClicked(MasterList1_btnClicked);
}

void MasterList1_btnClicked(object obj, EventArgs e)
{
hdnURL.Value = MasterList1.URL;
cont = LoadControl(hdnURL.Value.ToString());
plMasterList.Controls.Add(cont);
}
this is the code where I'm calling delegate to load..

is that what you was asking for.....

I have used this inside update panel. OnClick of user control any event it just disappear and no event fire. dont know why..

I have done this.

you can create single function for doing this. and can you that every where...

either you can use following

Private Sub Form13_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim count As Integer
Dim count1 As Integer
Dim total As Integer
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\sachin\db1.mdb;Persist Security Info=True;Jet OLEDB:Database Password=admin")
con.Open()
Dim str1 as string = "select count(*) from answer where count=1 ;"
Dim str2 as string= "select count(*) from answer where count=0;"

Dim cmd As New OleDbCommand(str1, con)
Dim cmd1 As New OleDbCommand(str2, con)

count = CType(cmd.ExecuteScalar(), Integer)
count1 = CType(cmd1.ExecuteScalar(), Integer)
total = count - count1
Me.Label1.Text = total
con.Close()

he wants to check if user is logged in then only other page should display. other wise it should be redirected to login page.

yes, and i have done it.

I have tried to create common function but unable to do. I mean by doing programming work as I have done in the code mention. you can see I'm using same code in all function except txtboxid and lableID. I need programming work of function that allow me to do this with only one function.

how can i create one function to do this validation to reduce code size.

you need to create a new project for this. from setup and deployment. you can add frame work from there with you application. which is default provided by microsoft.

your connection string is not seems to be ok..

Send your table Design. I think you had taken wrong datatype.

great..........

ajax calender control work on click event and get focus of that control. when u r setting its property. it will not allow to write any thing on that and event will not work. that why you r facing this problem. Don't Make its property readonly.

Currently I'm using the same code given above but if providing to message box use this one of the code does not show or often in does not appear I want unless the button clicked it should be on top of windows. and user have to click this button to before going ahead......

it has only two colomn 'RegistrationNumber' 'BalanceAmount'.
actually in my case I want to insert data(payment) in One table and at the same time Want to update Remaining balance in oldbalance table. I want that either both statement commit or non. thats why I'm using transaction here. sql proc is running fine on back-end. But dont know how to use "sql proc" with trancsaction. there is coding mistake. but dont know what?

I want to do this with transaction

thanks

it's asp.net 3.5

you mean to say that you want coding of button click that check user in database and if exist than something happent according to u? or something else?

please correct your Question so that anybody can understand properly.

thanks for reply me but my application is in vb.net how it will work there.