ASP.NET

Bind File to Record in the Database

30-Mar-08 22:09

When you upload the file you can add file name with its path in the database. When the user go on the file listing you can easily display the file as a link from the database. I usually don't save files in the database until and unless I am very sure about their size and when its a requirement.

Faraz Shah Khan
MCP, MCAD.Net
Blog

Muhammad Gouda30-Mar-08 2:41

Muhammad Gouda

30-Mar-08 2:41

In my page, the visitor will fill in a form and can upload a file.
I do not need to save the file itself to the database, rather I save the file to a folder on the server with a reference in my table.
The Problem is:
if more than one file with the same name and extension were uploaded, each one will overwrite the older one
I have 2 solutions of my own:
1- I can create a sub-folder with a name same as the primary key of the record this file belongs to. and upload the file to that sub-folder
2- I can append the primary key as a prefex to the file name

But, I think this problem has more smart solution that I faild to find by google or even in codeproject articles

Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;

outside cosmic30-Mar-08 3:42

outside cosmic

30-Mar-08 3:42

SQL Server 2008 will have support for what you are trying to do - http://www.infoq.com/news/2007/12/SQL-Filestream[^] so until this is out your on the right tracks with your own solutions.

farazsk1130-Mar-08 22:13

30-Mar-08 22:13

What solutions you have suggested are good you can also do one more thing is to rename the file either with the primary key or some GUID name and keep the actual file name and path of the file in the database so that when you display the file you can show it with actual name and on the backend its with some different unique name.

Faraz Shah Khan
MCP, MCAD.Net
Blog

Muhammad Gouda30-Mar-08 22:24

Muhammad Gouda

30-Mar-08 22:24

Thanks
But I gussed there is more standarad direct solution

Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;

farazsk1130-Mar-08 22:42

30-Mar-08 22:42

To be more honest I have not seen any better solution so far as the above 3 solutions. any way there still can be a better way but I couldn't find any thing wrong in this one.

Faraz Shah Khan
MCP, MCAD.Net
Blog

Muhammad Gouda31-Mar-08 3:21

Muhammad Gouda

31-Mar-08 3:21

farazsk11 wrote:
but I couldn't find any thing wrong in this one.

One of the lacks of the above 3 solutions is that them all depend on the primarykey.
And I generate the primarykey on the submit event (for some reason)
So, how to use it in the upload event before it is generated Confused | :confused:

Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;

farazsk1131-Mar-08 7:17

div expand in master page [modified]

31-Mar-08 7:17

Well as a matter of fact I usually use GUID to rename files and as the GUID is generated in the code I pass it in the database. I usually store the GUID name and the actual name so that when the user request I can display it as actual name and on the backend i keep it with GUID.

Faraz Shah Khan
MCP, MCAD.Net
Blog

ksaw12329-Mar-08 23:15

ksaw123

29-Mar-08 23:15

I have a problem with using div in master page with a fixed CSS file. The div contains content panel. The content panel has a grid view or a data view or both. When they appear in the page, they go out of the page.
I tried to make the height = inhernt and also height = auto, but both of them didn't work.

How can I make the page expand to contain them/it as long as they expand?

Regards,

modified on Sunday, March 30, 2008 5:24 AM

Re: div expand in master page

jonhbt30-Mar-08 0:37

Re: div expand in master page

30-Mar-08 0:37

try not to give any property of height in the css file.

ksaw12330-Mar-08 4:43

ksaw123

30-Mar-08 4:43

I am not using CSS file. I am using inline code.

Re: div expand in master page

Mitch F.31-Mar-08 8:39

31-Mar-08 8:39

You might want to try giving your DIV the CSS attribute of overflow:auto;.

I hope this helps.

DIV locations

jonhbt29-Mar-08 21:00

Re: DIV locations [modified]

29-Mar-08 21:00

Can someone tell me please how can I change the location of a div when a page loads?
I need to change the location on the page of the div. I tried to use java script but i couldn't manage. Thanks infront

Mitch F.29-Mar-08 21:53

29-Mar-08 21:53

Does your DIV have an ID attribute? If so, if you want to move it using JavaScript, you could put the following code in the BODY section of the web page. Or, if you wanted to have the JavaScript in the HEAD section, you could turn the code into a function and have it called in the OnLoad event of the page.

<br />
<script type="text/javascript"><br />
myDiv = document.getElementById("theDivID");<br />
myDiv.style.left = fillIn+ "px";<br />
myDiv.style.top = fillIn+ "px";<br />
</script>

(Note, replace both fillIn with integers and theDivID is the actual ID of the div)

I hope this helps.

modified on Sunday, March 30, 2008 3:59 AM

jonhbt30-Mar-08 0:35

30-Mar-08 0:35

And how can i call a function in the onload of the page code and pass the variables?. i tried various ways but with no results. I am still a beginner in javascript so i m new to its funcitonality

Mitch F.30-Mar-08 9:58

30-Mar-08 9:58

Where are you getting the new left and top values for the DIV tag? (Eg, inside of the ASP.Net page's code, or through JavaScript?)

If you are getting the values through ASP code, you won't have to use any JavaScript; just add the runat="server" attribute into the DIV tag and change the Left and Top values through your ASP code.

I hope this helps.

jonhbt30-Mar-08 20:16

30-Mar-08 20:16

I am getting the values thorugh code. How can I pass them through ASP code. I tried to do the following but with no success.

*runner is the name of the div
runner.Style.Add("left", xpos.ToString());

Thanks for your help

Mitch F.31-Mar-08 8:35