|
How I Restore data from datatable to database within one step using c#.NET 2.0+MSSQL 2005
|
|
|
|
|
Let me get this straight -
1) You have a System.Data.DataTable object with data
2) You want to replace the data in a SQL Server table with the data in the System.Data.DataTable
With ADO.NET, using a data table you'd have to do it in two steps:
1) send a TRUNCATE TABLE statement to SQL Server using a SqlCommand object.
2) use the SqlDataAdapter.Update() method to insert the new records (just make sure that the row version for each row is set to "new").
|
|
|
|
|
Hi!
i m developing web portal in C# asp.net web application. i want to display image in hyperlink control rather than text. i can do it by using hyperlink's property that is 'imageurl', but problem is that in hyperlink,image displays in actual size not in that size which i have given in hyperlink height and width property.
can u plz tell me how i can restrict size of hyperlink upto my own requirment i mean i want to display all the images in hyperlink of size 100/100,even if image actual size is 500/500. just as i can do in image control.No matter how big image is but it always displays in that fixed size which i give to it.
Thanx
|
|
|
|
|
Before I start, let me just say that if you want the images to display as 100x100, then it would be best and easier to simply resize the image and save it that way. However here are some options:
1) The easiest is to use HTML controls (an anchor "A" tag wrapped around an image "IMG" tag) instead of server controls. This is what is being rendered for you right now anyway when you are using the ImageUrl property of the Hyperlink control. The problem with it is that it doesn't set the Height and Width of the IMG element, it sets it for the A element. This is your best alternative.
2) If you are using the Hyperlink control because you want to use it for a postback event, then use the ImageButton control instead. The height and width properties of the ImageButton control will work in this case.
|
|
|
|
|
Hi
I am frequently getting the following type of Error Message ..
when i Restart my IIS Server its working. can anyone help me on this issue.
Error Message
1.IIS Out-Of-Process Pooled Applications or Some time IIS will show Error msg like
RPC Server unavailable
Raji,
Application Developer
|
|
|
|
|
I'm using the following HTML code in emails to make the words move from up to down....
it works with Hotmail but it dosent work with Yahoo!....why?
I used the code which make the words move from right to left and it works with both Yahoo! and Hotmail
why the code of up to down or down to up dosent work with Yahoo??!!
while the code of right to left or left to right works with Yahoo
the code is :
<center><marquee direction="down" width="350" height="200" style="TAHOMA: 150%; font-size: 14pt; color: white; border-style: ridge; border-color: #0066FF" bgcolor="#000000" scrolldelay="100" scrollamount="3"><center>
<br>
<br>
<br>
WRITE HERE
<br>
<br>
<br>
</marquee>
<br>
|
|
|
|
|
sounds like yahoo is stripping the tag. Wise of them, really.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
sorry...I didnt understand
I just want a way to make the words move from down to up in Yahoo mail
I can make them move from left to right or write to left
but i cant do that for up to down or down to up
plz heeeeeeeelp
|
|
|
|
|
Hi
I want to have a link that upon clicking on it, it open SaveAs Dialog for saving a file. Just like we have the file URL and we right click on it and click Save Target As... I want to do it with just one click.
thanks
|
|
|
|
|
This is a server side trick with Content-Disposition HTTP header. See this.
P.S. However, you can also look here.
-------------------------
Listen up! Teamwork means staying out of my way! (Seifer, Final Fantasy 8).
|
|
|
|
|
Is there a way to manipulate a server control with client script?
I have a System.Web.UI.WebControls.Menu control on my page. When the user selects a particular style sheet from a select control, I want to change the Orientation property of the Menu control from "Horizontal" to "Vertical".
How can I go about this?
Thanks!
Ian
|
|
|
|
|
you can store something in a hidden field that causes it to change on the server, and do a postback.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Guffa wrote: Can you describe what it is that you think is incorrect with the way that IE6 displays the page?
Render the supplied html in both ie6 and firefox, and look at the middle two red table cells on the top row. In IE, the left cell is MUCH wider than it is in firefox. Firefox is displaying it the way I think it should be displayed.
BTW, I'm on a 19-inch 1280x1024 display.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
The standard for the width of a container type element is the with of its content. However, IE6/IE7 in non STRICT mode adds the content plus the padding plus the border into the width of the container element. To avoid this, use the HTML 4.0 Strict doctype or higher.
|
|
|
|
|
Changing the doctype had absolutely no affect in either IE or FireFox. Besides that, the problem I cited is not merely content + border + padding.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
You have only specified the minimum with of the cells (that's how tables work), so the browser can choose the size of the cells freely, as long as they are at least the size that you specified.
If you use tables for layout and don't want the browser to make any decisions about the size of cells, you have to specify the size for every single column in the table.
---
single minded; short sighted; long gone;
|
|
|
|
|
Tables are okay for a quick-and-dirty layout. However, the current trend suggests not using tables for layout but for displaying data that is best viewed in a grid. Your problem is reflected in the standard behavior of a table. Go to this web site, http://www.alistapart.com/[^], and you may find some information that might help.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Man, I really hate html/css...
Here's some html that displays correctly in Firefox, but incorrectly in IE6. Can anyone tell me how to make it look the same in IE6?
The problem concerns the two center red cells in the top row.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>My Web page</title>
<meta http-equiv="Expires" content="0" />
</head>
<body>
<table width="100%" cellspacing="1">
<tr>
<td style="background-color:#ff0000; height:58px; width:30px;" ></td>
<td style="background-color:#ff0000; height:58px; width:331px;"></td>
<td style="background-color:#ff0000; height:58px;"> </td>
<td style="background-color:#ff0000; height:58px; width:15px;"> </td>
</tr>
<tr>
<td style="background-color:#ff0000;width:30px;"></td>
<td colspan="2">
<table class="med" style="width:100%; background-color:#aaaaaa;" cellpadding="0" cellspacing="1">
<tr>
<th style="width:100px;">1</th>
<th style="width:100px;">2</th>
<th style="width:48px;" >3</th>
<th style="width:38px;" >4</th>
<th style="width:46px;" >5</th>
<th style="width:60px;" >6</th>
<th >Really wide column 7</th>
<th style="width:75px;" >8</th>
<th style="width:75px;" >9</th>
<th style="width:75px;" >0</th>
<th style="width:14px;" >A</th>
<th style="width:14px;" >B</th>
<th style="width:58px;" >C</th>
<th style="width:58px;" >D</th>
<th style="width:26px;" >E</th>
<th style="width:26px;" >F</th>
<th style="width:26px;" >G</th>
</tr>
</table>
</td>
<td style="background-color:#ff0000;width:15px;"></td>
</tr>
<tr>
<td style="background-color:#ff0000;height:15px;width:30px;"></td>
<td colspan="2" style="background-color:#ff0000;height:15px;"></td>
<td style="background-color:#ff0000;height:15px;width:15px;"></td>
</tr>
</table>
</body>
</html>
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Try to write a subject that says something about the problem.
Can you describe what it is that you think is incorrect with the way that IE6 displays the page?
---
single minded; short sighted; long gone;
|
|
|
|
|
I have tried and modified your code.. both browser is working fine
see the code below:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><br />
<html xmlns="http://www.w3.org/1999/xhtml"><br />
<head><br />
<title>My Web page</title><br />
<meta http-equiv="Expires" content="0" /><br />
</head><br />
<body><br />
<br />
<table width="100%" cellspacing="1"><br />
<tr><br />
<td style="background-color:#ff0000;width:30px;"></td><br />
<td colspan="2" style="background-color:#ff0000; height:58px; width:980px;"></td> <br />
<td style="background-color:#ff0000; height:58px; width:15px;"></td><br />
</tr><br />
<tr><br />
<td style="background-color:#ff0000;width:30px;"></td><br />
<td colspan="2"><br />
<table style=" height:58px; width:980px; background-color:#aaaaaa;"><br />
<tr><br />
<th style="width:100px;">1</th><br />
<th style="width:100px;">2</th><br />
<th style="width:48px;" >3</th><br />
<th style="width:38px;" >4</th><br />
<th style="width:46px;" >5</th><br />
<th style="width:60px;" >6</th><br />
<th >Really wide column 7</th><br />
<th style="width:75px;" >8</th><br />
<th style="width:75px;" >9</th><br />
<th style="width:75px;" >0</th><br />
<th style="width:14px;" >A</th><br />
<th style="width:14px;" >B</th><br />
<th style="width:58px;" >C</th><br />
<th style="width:58px;" >D</th><br />
<th style="width:26px;" >E</th><br />
<th style="width:26px;" >F</th><br />
<th style="width:26px;" >G</th><br />
</tr><br />
</table><br />
</td><br />
<td style="background-color:#ff0000; height:58px; width:15px;"></td><br />
</tr><br />
<tr><br />
<td style="background-color:#ff0000;width:30px;"></td><br />
<td colspan="2" style="background-color:#ff0000; height:58px; width:980px;"></td> <br />
<td style="background-color:#ff0000; height:58px; width:15px;"></td><br />
</tr><br />
</table><br />
<br />
</body><br />
</html>
Harini
|
|
|
|
|
Hi
I am developing web toolbar I need images of toolbar buttons like "New", "Save", "Cancel" and "Delete". If any person have images kindly send to following address.
Shahzad Aslam
Software Engineer
shehzadaslam@hotmail.com
|
|
|
|
|
google image search.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello to all,
Which one is flexible/optimal solution to save uplaoded image.
Frist save image at server or from where you're site pages are save in any image folder and save only image name or link to database.
Secondly convert image to bite form then save whole bite form image to database.
My friends feel that second one is right choice, but i felt that frist one is correct as conversion procedure and retrival from database is completly time consuming and not correct from web hosting point of view.
Feel free to give all kind of suggestion.
Smita
|
|
|
|
|
Just 'cause you can doesn't mean you should. I don't believe the 2nd solution scales very well, or at least not as easily as the first.
Storing image files in a database increases managment overhead and maintenance windows for backups/restores. As the amount of image data stored increases you have to create separate filegroups for the image data. Then you have to put those filegroups on different disk arrays. But unless you can afford Enterprise Edition 2005 that's as far as you can scale. Ent Ed will allow you to partition the table across file groups and you can add new disk arrays to reduce the IO. But still you're only going to get so far before you've completely bloated your database and created all kinds of headaches. All of which involve figuring out how to scale UP, which is more expensive and not necessary in this case.
On the other hand if you store your images on a file server, when it fills up or becomes overloaded, you just change the path root used to store new images and you can scale OUT by adding a new server or location for the files. You can leave the old files where they are.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
