Comments by sabbi26 - CodeProject

sabbi26 12-Nov-12 6:43am View

Hi shahzads,

I almost used same logic

Declare @Id varchar(8) = ''
Select @Id = 'P' + RIGHT('0000000' + Cast((CAST(SUBSTRING(lastGeneratedId, 2, (LEN(lastGeneratedId) - 1)) as int) + 1) as varchar(7)), 7) from
(
Select MAX(ID) as lastGeneratedId
from MyTable
) as A

but it's not working.
problem is before inserting my generated ID it's inserting by another user from another session.
So i am assuming Scope_Identity or Identity_Current will solve my problem?

sabbi26 12-Nov-12 6:43am View

Deleted

Hi shahzads,

I almost used same logic

Declare @Id varchar(8) = ''
Select @Id = 'P' + RIGHT('0000000' + Cast((CAST(SUBSTRING(lastGeneratedId, 2, (LEN(lastGeneratedId) - 1)) as int) + 1) as varchar(7)), 7) from
(
Select MAX(PatientID) as lastGeneratedId
from MyTable
) as A

but it's not working.
problem is before inserting my generated ID it's inserting by another user from another session.
So i am assuming Scope_Identity or Identity_Current will solve my problem?

sabbi26 15-Nov-11 23:42pm View

Check the user have permissions to read and write the file in file server.

sabbi26 7-Nov-11 5:36am View

Thank u i tried it before for entire folder it's not worked. but now i tried for particular file it's work like charm.

sabbi26 3-Nov-11 3:01am View

Create usercontrol of type DateTimePicker and use in the application.

sabbi26 2-Nov-11 8:29am View

simply send the path value as a string to the database and save in the table column of type Varchar(50).

when reading the file simply "Select FilePath From Table1" it gets file Path than u need to pass that FilePath as a url to linkButton or hyperlink what ever it is. That's it nothing more

sabbi26 2-Nov-11 7:25am View

what actually u need to store in Database (File or FilePath)

sabbi26 2-Nov-11 6:41am View

please provide some info about ur problem

sabbi26 2-Nov-11 5:20am View

i am not getting what's ur requirement.
u can simply assign the table column's value to the label by using above code.
"label.Text = "yourtablevalueobject.tostring()""

sabbi26 2-Nov-11 3:25am View

than write that method.In that get the values and assign to the second drop down list.
I hope it will fix ur problem

sabbi26 2-Nov-11 3:13am View

are u wrote the code for ddlfirst__SelectedIndexChanged event in ur aspx.cs file.
if u wrote already please post the code

sabbi26 28-Oct-11 0:59am View

Once the session expires the data in the session cache is no more.If u want to maintain the session for long time set the session timeout property to more in web.config.
If ur page contain any secured info pls avoid sessions with longer timeout values.

sabbi26 25-Oct-11 7:07am View

to send data from one page to another the best way is using Session variables. instead of Querystring use session variable.

sabbi26 24-Oct-11 9:19am View

Thanks sachin I will let u know if i have any query's

sabbi26 24-Oct-11 6:18am View

make sure the needed plugins for uploading video file are installed in IE or Not.

sabbi26 21-Oct-11 8:02am View

It's not the server problem if u manually try to login to remote server it's not accepting anonymous login or client code also not getting data if i didn't call that impersonate method.
My problem is the method accepting any username and password at debug time if i change the values

sabbi26 18-Oct-11 8:09am View

Better to write a server side event for the button and in that u make it as disabled.

sabbi26 18-Oct-11 7:11am View

what u need ?..ur asking how to create a text file with name,how to read and write?

Comments by sabbi26 (Top 18 by date)