VS 2005 - Compact Design With Tables?
Jan 30, 2010tables to get compact design and i am having lots of problems with it also.
View 2 Repliestables to get compact design and i am having lots of problems with it also.
View 2 RepliesI am having some trouble with designing a masterpage for my site. In IE 8 the left menu pane stretches out every time i add a pic to the top table. When in compatiblity mode this is not a problem
View 14 RepliesI am a little confused what approach I should make as my standard designing web pages. I have been reading about relative and absolute positioning. Articles I have come accross seems to favour both. So from the experts I would like to know what standard I should adopt. Is there a combination that is good, example have panels be absolute and controls within be relative. I find it hard to work with relative positioning especially when you have to insert new control between already existing controls. Maybe I am doing things wrong?
View 22 Repliesi need to create div on run time in such a manner as it create table at run time,(table is also in another div) .
all my rows in table like this (for example)
Code:
[code]....
let me tell u one more thing above div is sub div of many other divs .how i will access how to add runtime to design time div?
I am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
Which is more efficient out of the above two.
how would you design a search box to position control properly.
Code:
[code]....
i want to know what to do after desining a page with photoshop and fireworks to make an asp master page using visual studiosimply i have an html page i want to make a master page from it
View 2 RepliesC:Program FilesMicrosoft SQL Server100COM>tablediff -sourceserver "warehousebox"
-sourcedatabase "table1" -sourcetable "siqvirtual" -destinationserver "mainbox" -de
stinationdatabase "table1" -destinationtable "siqvirtual" -destinationuser "sarah"
-destinationpassword "hello" -strict -f "c:fooDiff.sql"
Since these table are on two different boxes and 2 different versions, I am getting error message that tables cant be compared because they have different schema's.Schema's are the same but they are on different machines and different servers. What is a work around it?
i am unable to handle jquery accordian. I want to bind it to ta database. I wanted that the user shuld be able to enter the values in a text box through an admin panel which i shoud make for him and those values should be displayed in the accordion panel through the database but........... I am unable to connect and show daabse values in accordian.. don't know whether my connection is not ok or my technique is wrong can anyone help me in this regard??
Here is the code for making the connection..
protected
void Page_Load(object sender,
EventArgs e)// Create a connection to the "DatabaseAccordian" SQL database located on the
// local computer. {
SqlConnection myConnection =
new
SqlConnection("server=localhost;" +"database=DatabaseAccordian;Trusted_Connection=Yes");//
Connect to the SQL database using a SQL SELECT query to get all
// the data from the "AccordianEvent" table.
SqlDataAdapter myCommand =
new
SqlDataAdapter("SELECT * " +"
from AccordianEvent", myConnection);// Create and fill a DataSet. myCommand.Fill(ds);
{DataSet ds =
new
DataSet();if (ds !=
null)// Bind MyDataList to the DataSet. MyDataList is the ID for
// the DataList control in the HTML section of the page.
MyDataList.DataSource = ds;
MyDataList.DataBind();
}
else Response.Write("<p>No customer selected</p>");}
this code is compiled code with no syntax error.
if there is any other thing needed to be done for making the connecion.
<div
id="accordion"> <h3
style="color: Black">
<a
href="#">News & Announcements</a></h3>
<div>
<p>
23rd March will be a holiday
</p>
</div>
<h3
style="color: ThreeDDarkShadow;">
<a
href="#">Events</a></h3>
<div
id="divEvents">
</div>
</div>
i am trying to compare four columns in two tables(both are in the same schema), table a has two columns for firstname and last name , table b has similar columns firstname and last name, i wish to compare both and if there are similarities, do nothing but if there are differencies, export or write them to a exception or error table.. not quite sure what if statement i should write or how to go about this.
View 6 RepliesI am trying to transfer some tables and stored procedures from SQL Server 2005 to Express 2008. I have tried using Management studio, but it isn't working....
View 5 RepliesAs I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
I want connect to SQL Server Compact 4.0 in my ASP.NET application..
Here is example of code:
protected void Page_Load(object sendhttp://stackoverflow.com/questions/asker, EventArgs e)
{
string connStr = "Data Source=D:\MyDB.sdf;";
string sqlStr = "select * from tblMyTable";
var sqlDataSrc = new SqlDataSource(connStr, sqlStr);
GridWithUrls.DataSource = sqlDataSrc;
GridWithUrls.DataBind();
}
But I have the next error:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
The SqlDataSource has constructor with three parameters, one of them is 'providerName' so, how to specify that I want definitely use Sql Server Compact provider ? Also I have added System.Data.SqlServerCe reference..
I'm currently trying to install the "new" Microsoft WebMatrix Beta 2 (a web programming IDE). I was trying to use Web Platform Installer for this. But it 404's on the SQL Compact 4.0 CPT2 and it's tools. I was able to get the runtime from the Microsoft downloads page but the tools I am not able to find. I can not install WebMatrix because the tools are a prerequisite.
View 2 RepliesI am working on a CMS project using ASP.Net 3.5/Visual studio 2008.This is the first week of the project and I am working on the design of the system right now. Needless to say that this is my first project of this scale and I have no idea of what I am doing.
The requirements of the project ask for a light but functional CMS, one which is easy to deploy.So the question is which database to use in this scenario SQLCE or SQLite?
i am trying to use a compact db in my web site, all works well with a absolute address to the file "c:mydirmydb.sdf"
but i dont want to use a absolute address for deployment reasons. i want to use somthing like |datadirectory to find the file.
This is a connection string for a entity model. somthing like
<
add
name="MyEntities"
connectionString="metadata=res://*/Entity.csdl|res://*/Entity.ssdl|res://*/Entity.msl;provider=System.Data.SqlServerCe.3.5;provider
connection string="Data
Source=|DataDirectory|mydb.sdf;Password=xxxxxxxx;Persist Security Info=True""
providerName="System.Data.EntityClient"
/>
have been trying to implement in a different scenario the example at the following URL: http://blogs.msdn.com/b/markprenticems/archive/2007/03/27/introduction-to-windows-communication-foundation-for-the-net-compact-framework-messaging-stack.aspxHave tried few things, but I cannot find a way to modify the following snippet (included in the above link) to send requests to methods with different parameters/signatures
View 1 RepliesMSChart created a temp compact database ( ASPNET.MDF ).
This was on my personal laptop. I'm moving the project to another PC for a demo at work. But, my sa password is different now.
How do you login to this database? or can I run a utility to push the tables to sql server instead?
I keep getting the sa password fails message, because the laptop and work have different passwords.
i have installed visual studio 2010 sp1, i have installed everything to do with compact 4 from web platform installer. yet when i try to connect to a compact 4 database, their is no choice for compact 4, there is a choice for compact 3.5 but no 4. If i try to connect using tthe 3.5 choice i get an error. i can add a compact 4 database from the new items menu. but i can not make a connection to it.you can see in this tutorial compact 4 listed in the add connectiojn box, but it is not listed in mine[URL]
View 4 Repliesquery in SQL Server Express, which worked fine, now I am trying to do it in WebMatrix using a Compact 4.0 db but it gives me an error.
SELECT *, (SELECT
count(1)
FROM Posts
WHERE CategoryI
[code]...
I have come accross a scott's blog today;
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?
How can I handle more than 4k of text on the new SQL Compact Edition 4? nvarchar only supports 4k and when I change to ntext, I get the same exception as I get using nvarchar(4k), when using the Microsoft.Data wrapper included with Microsoft WebMatrix. Should it normally work using ntext?
View 2 Repliescan't connect to sql 2005 express sp1 and vs is also sp1. 2) Which my guess is because of the database connection not being able... design view is not able to pull in the application for design, it's as if there is no theme and css just white background and black print.
View 1 RepliesI installed Rad Controls. Using that controls, I designed my application pages. At design time, the design is not visible. It shows the following error:
RadTabStrip1Failed to create designer 'Telerik.Web.UI.RadTabStrip, Telerik.Web.UI, Version=2010.1.415.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4'
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 Replies