I have a database that I just migrated data to. It has grown to 769MB from 13MB when I shrink it, it does not get any smaller. I don't think the amount of data should have made it grow that much. Could I be doing something wrong?
View 3 Repliesthis is my css for the mobile version I was just wondering how I can change the size of the textboxes for the mobile version to make them smaller but don't change on the computer version? if you go here on the mobile version youll see what I mean URL... the code for the form is inside this class tag.
<section class="left-col">
</secion>
PHP Code:
/*--------MEDIA!!!-----------*/@media screen and (max-width: 478px){ body{
font-size: 13px; }}@media screen and (max-width: 740px){ nav {
width: 100%; margin-bottom: 10px; } nav ul{ list-style: none;
margin: 0 auto; padding-left: 0px; } nav ul li{ text-align: center;
margin-left: 0 auto; width: 100%; border-top: 1px solid #878E63;
[Code]......
I have written a website and let the user upload their photo. It also resizes the picture to 400 x 400 and crops automatically to the center part of the picture. All of this works good but each file is about 355K each for JPG and PNG file formats. I just tried GIF and it is 49K but the picture is grainy when saved this way. Is there any way I can get the picture to a smaller file size with keeping it at 400 x 400? I really thought PNG would be the way to go and was surprised by it being the same as jpg. I don't want to lower the quality either for JPG files.
View 1 RepliesIf i have created 1 database. then what would be the max size of that database in sql server 2000 & Sql server 2005?
View 3 RepliesFrom using the command: EXEC sp_spaceused on a SQL 2008 database,
the DB has a size of 642.56 MB, unallocated space 148.77 MB.
I can also see the size of the individual tables from the same command:
Reserved: 103656 KB
Data: 98264 KB
Index_size: 2656 KB
Unused: 2736 KB
What I don't quite get is why the total database size is 642.56 MB when the size of the individual tables is so much smaller. We pay for the total amount, in chunks of 500 MB. I was trying to see which tables where causing the DB to be so big, but to me, it looks like it is not the size of the tables but something else.
What should I look at to figure out why we are taking up so much space? Am I not understanding how this works?
In one grid there is only one column and entries are 100+, all entries are hyperlink entries, but the gridview does not look nice with one column and 100+entries, is there any way I can split that entries in 3-4 coluns to look even.
View 3 RepliesI have an output parameter called '@packIds', that I create in ADO.Net using the code below:
SqlParameter packIdPara = new SqlParameter("@packIds", null);
packIdPara.SqlDbType = SqlDbType.VarChar;
packIdPara.Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add(packIdPara);
How will I specify that the parameter '@packIds' is of max size? I cannot find any code for this.
[Code]....
I want to grab some values with a form and then do a lookup via a datareader in a data access class (N-Tier).
I want to return a data list and bind that to a form view control.
Here is some code from the DAL, Business object and search form.
The parameterized query doesn't like the data being passed to it from my web page .
[code]....
[Code]....
Where is the nvarchar size of 4000 coming from ?
I am using TabContainer with some controls on each tab (asp: labels, text boxes). When redirecting to the page that contains the TabContainer, the tabs and their content loads as expected, but when there is a postback, and the page refreshes, the TabContainer UI changes - the font size of the labels gets bigger, the text boxes become bigger and their location changes a bit (not aligned as before), and the tab header is partially hidden. I am using IE7.
I dont know if this is relevant but in some of the text boxes i use edit mask extender as well for date. Also, I have used a table inside the TabContainer for layouting the controls.
The asp.net chart control (pie) is becoming smaller and smaller as I add more and more legend items. How can I prevent this? If I set the maximum space that the legend can take, items are getting truncated. Therefore, I want to find a way to dynamically set the size of the chart.
View 1 RepliesI have the a test harness detailed below. This has two labels on the page that are set within the page_load which is hit every second due to the updatepanel and timer.
Label1 is set to a datetime value that is stored in the Cache. Label2 is set to the current datetime.
The cache is set with an absolute expiry of 5 seconds from now and there is an update callback on the cache to re-set the datetime and make it valid for another 5 seconds.
The problem I have is that I'm seeing the cache update every 20 seconds, not every 5 seconds like I would expect. If I set the time to 30 seconds then it updates every 40.
This appears to indicate that the cache will only expire every 20 seconds. Does anyone know of a way of reducing this time? If I just insert into the cache with an expiry of 5 seconds and no Callback then it works as I would expect and is removed every 5 seconds.
ASPX:
[Code]....
Ive downloaded AspNetAjaxLibraryBeta0911 and have added both System.Web.Ajax.dll and AjaxControlToolkit.dll from the webforms/debug folder to my [ASP.NET web app] project. I have also added the latter dll to my toolbox. Ive dragged a ToolkitScriptManager onto my aspx page too, and it has created these two reference:
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Assembly="System.Web.Ajax" Namespace="System.Web.UI" TagPrefix="asp" %>
Is that right so far? Now I want to have a custom HTMLEditor, so I created a new folder "App_Code" and created a class calles CustomEditor.cs which has this content:
using AjaxControlToolkit.HTMLEditor;
namespace TestProj.App_Code
{
public class CustomEditor : Editor
{
protected override void FillTopToolbar()
{
TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Bold());
TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Italic());
TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Underline());
}
}
and then I added this to the aspx page:
<%@ Register namespace="TestProj.App_Code" tagprefix="custom" %>
and
<custom:CustomEditor ID="editorMsg" runat="server" />
Firstly, it works. But I have a few problems.
1) In CustomEditor.cs there is no intellisense, and pressing Ctrl + Space bring up no things like "TopToolbar" etc.
2) In the aspx page's designer code I had to add this manually: protected global::AjaxControlToolkit.HTMLEditor.Editor editorMsg; else it wouldnt come up in my code behind. Why isnt it automatically doing that? And is that correct?
3) No matter what I do I cannot make the editor's height smaller than 200px. I set it both inline and in code behind but it still overflows its container and goes to 200. I can however make it more than 200 and also width is fine. Heres a screenshot: [URL]
I have three panels like so:
___ _________ ___
| | | | | |
| | | | | |
| | | | | |
| | | | | |
|___| |_________| |___|
But if I shorten the window a little bit, the middle panel goes below the two side panels:
___ ___
| | | |
| | | |
| | | |
| | | |
|___| |___|
_________
| |
| |
| |
| |
|_________|
Here is my code
<style>
.SidePanel {
background-color:#9999CC;[code]....
I have two textbox as naming : txtInitiateDt and txtDisposalDt.
When user give 2nd textbox value from datepicker it should chk whether the given value shouldn't more than to date and also less that 1st textbox value.
I did it & also works good...bt there's an error arise when i host the site on client machine where only framework and database is present.
And the error is "String Value is not in correct dateformat" and fr this exception other events are blocked.
My admin set innodb_buffer_pool_size=512M, innodb_log_file_size=128M, and innodb_log_buffer_size=1M although in mysql query show global variables its showing what the value is set. When i restart my system also its showing what we set the data.(It means we set log file buffer file size to max and its working fine.) but when i try to upload a file of 58 mb again its throwing error as The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size.
View 1 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesi would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
View 1 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
Does it make a difference in terms of the actual size of the database if I define one of the columns as nvarchar(100)? If there are restrictions on the form as for how much you can input, let's say 50 characters, does the db save blank spaces from character 51-100 and create a database that is larger than it would be it the column was defined as nvarchar(50)?
View 2 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI have an application that allows users to upload a pdf. I am saving the PDF into SQL (I know already this is not the best practice, but it was not my decision) and I need to some how duing this upload process reduce the size of the pdf. Is there a way to get the uploaded file, reduce its size, then stream it to SQL?
View 12 RepliesI have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
I want decrease my database's file size I mean I want decrease .ldf and .mdf file's size... How I can do it?
View 1 Replies