|
i have a gridview which is storing a record .i want to generate a unique no while saving one record.
the format should be like (pscode(2place),year(4place)and num(4place))
example:--01-2007-0001
where ps_code is char(2),
year come form date-which is of date and time datattype
and the last 4 place are char(4),
where ps_code and date are the field of my data base.i want retrive ps_code and year from my database to generate the unique number.
can tell me how will i do it?
i am devloping a web applcation where the backend is vb.net2005.
|
|
|
|
|
select Max last number of Unique code and increament it by 1
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
Hi first u create one column for that no,then if u enable identity as true then below that they put increment as 1 by default , if u need increment by 2 or any value u can put , u ref that increment value to that column (ie new column for that no) , then that no's stored in that column u can ref that column u can easly fetch that no
Reg
Nanthakumar
|
|
|
|
|
Hi u generate unique no thr sqlserver , there identity proper is there u changed as true then u can generate...
steps
1.open ur table thr Sqlserver enterprise manages then open ur table below ur table that identity option is there
Reg
Nantha
|
|
|
|
|
What is 'ur' table?
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"I haven't spoken to my wife now for 48 hours. I don't like to interrupt her.
|
|
|
|
|
If I understand your problem you need a unique integer when saving your record. Why not just use an identity column in your table and return that through an output parameter in your save procedure?
Another approach I've seen often is using GUID. You can generate that at the time your object is created and it (is supposed to) be unique.
HTH
J
Make the logo bigger
|
|
|
|
|
I have a web page.My requirment is that i have to show date and time on the status bar of the page.can u plz solve my problem.
thanking u
|
|
|
|
|
|
Hi
I am looking for a Condition clause in XML like "WHERE" in SQL.
If the XML file is like.....
<Details>
<Person>
<ID>100</ID>
<Name>Mr.X</Name>
</Person>
<Person>
<ID>101</ID>
<Name>Mr.Y</Name>
</Person>
.....
.....
</Root>
If I want the Name of a person with ID = 100
Fisrt of all how to Search for that ID in XML file, after that how can I get the Name for that ID.
I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison
Thank u
Chandu
|
|
|
|
|
Once you load this XML into a dataset, DataTable Select should help you out. Even a DataView RowFilter can be used right?
|
|
|
|
|
helllo frnd,
how can i shft my HTML table cotent to EXCEL with header and all
please help...
thankx in advance
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
The easiest way is to run the following code before outputing your current HTML:
<%
Call Response.Clear()
Session("REPORTCOUNT") = CLng(Session("REPORTCOUNT")) + 1
Call Response.AddHeader("Content-Disposition", _
"attachment; filename=Report_" & Session("REPORTCOUNT") & ".xls")
Response.ContentType = "application/vnd.ms-excel"
%>This basically tells your browser that it is opening an MS-Excel spreadsheet. MS-Excel is able to the HTML in spreadsheet format. You can even use simple CSS and the HTML table attributes (e.g. "bgcolor") to make things reeeeally pretty.
I use the REPORTCOUNT session variable to allow me to allocate unique filenames because Excel doesn't like having two spreadsheets open with the same name. The only niggle is that when you choose "File->Save As" from Excel menu, it initially assumes that you want to save an HTML-formatted file.
Other methods are to use ASP to write out in the XML Excel format introduced by Office 2003, or to use ADO to write to an Excel spreadsheet connection - then download the resulting file.
Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
Hi all
How upload msaccess(.mdb) file using Asp.net.
It is possible,
thanks
|
|
|
|
|
How upload 1gb file upload using asp.net client side
thanks
|
|
|
|
|
If you want to upload files that are going to be of a rather large size, you will have to make a change to your web config file. You will need to specify a maxRequestLength equal to the largest size file you plan to allow. The default is 4096 which is 4 MB.
http://msdn2.microsoft.com/en-gb/library/e1f13641.aspx[^]
Good Luck.
|
|
|
|
|
The problem with using the basic file upload control is that the server side will need to allocate memory equal to the size of the file getting uploaded. Where I work we used to use the basic file upload control and whenever someone would upload a 600MB file IIS for ALL people would stop responding and the server showed the worker process using 600+ MB of memory.
For that size of file I highly recommend using the free NeatUpload[^] component. Not only will it give you a progress bar it also won't consume much memory because it takes chunks postback stream and saves it to a temp file and responds with a progress message. Also, during the upload the client can cancel the upload. I have successfully uploaded 1.7+ GB without any problems and the server memory usage went up by about 10MB which is very acceptable.
Kelly Herald
Software Developer
|
|
|
|
|
rajmani wrote: How upload msaccess(.mdb) file using Asp.net.
Use FileUpload control. File type doesn't matter
|
|
|
|
|
|
Hi!
i want..... when i enter on a textbox cursor move to next field
|
|
|
|
|
hello frnd,
it can be achived by the Javascript/VbScript just use the "onKeyDown" event and check that
if event.keyCode = 13
{
document.getElementById("txtSecond").focus();
}
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Thanks for help
dear but can you tell me how can i get the next textbox name...
|
|
|
|
|
fmlove wrote: dear but can you tell me how can i get the next textbox name..
You have your page or project with you. isn't it? So, go and take a look... and decide which textbox you want the cursor to move when you press the "Enter" key.
OR Do you wanna detect automatically to the next control after current one?? It's hard to say since it is based on the design.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
HI!
i have two Text Box (TextBox1,TextBox2) and the maxlength for TextBox1 is 3 and for TextBox2 is 7. now i want when maxlength of TextBox1 is end then cursor automatically move on next TextBox2....Please help....
|
|
|
|
|
Write a javascript function and call it in OnKeyDown event of the textbox. Inside this function check the length of the text, if it is your desired length change focus to next textbox.
|
|
|
|
|
im giving treeview node colour using this code (shown below)
treenode.Text =
"<font color = #066C57 >" Addition "</font>";
bt at that time its tooltip is showing
"<font color = #066C57 >" Addition "</font>";
when im giving treenode.tooltip="something" it is nt working
pls give me a solution
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
