I have a C#/Asp.net web application which caches SQL DB schema information. Is there a way that I can determine what child relationships a given table has? I have looked into using the DataTable.ChildRelations property, but it is never populated with items unless i manually create a relationship using the .add property. I also have access to DataColumn information for each column in the database.
View 4 RepliesI would like to check my database for to see if a user name is available but my script isn't working.
I am taking input from a text box call unametextbox and i'm trying to extract any matching username from the database, this is my code.
[Code]....
I've added the section below trying to have my menu displayed correctly in the Chrome browser.
However, VS2008 complains:
Message 1 Could not find schema information for the element 'case'.
Message 2 Could not find schema information for the attribute 'match'.
From web.config:
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
[code]...
I already may have access to the solution i am after but cant find a way to keep the data and schema the same during deployment, ie development server SQL database to be the same thing as what i put on the sql server host during the deployment of the web application
i was using Quest Rocket compare to sync data and schema, it worked fine but they dropped that project with the intro by MS of VS08, ie the Quest plug-in works in VS05 but not in VS08 anyway, i probably have the solution I am after at my disposal due to my MSDN subscription which includes SQL server products, but my first problem there, is that i cant identify which MS tool to download and to use that will do the same thing or better than the Quest Rocket compare product,
i believe the solution i need is the full version of SQL Management Studio (which i think i have due to my MSDN subsctiption but my second problem 2) is i cant find in that full studio download in my MSDN subscriber area) also is it only the full verison of SQL Mgt studio and not the Express version that might have the "sync" capabiltiy, is that correct? or is there a way (I am a intemediate on SQL techonologies), within the Express Management Studio to painlessly sync both the schema and the data? I am using VS08 Pro, so mayber there is a way in the VSIDE to do the syncing, I think i tried the Publisher but ran into difficulties, am going to try that again and repost here what those difficulties were,
SO really just after a nice tool or utility that will keep SQL database schema and data the same during the deployment process for the web application i build, kinda urgent to as am buried and dont have time to breath.
I have 3 different databases where some tables are common.
View 16 RepliesI recently installed the latest Oracle Data Provider for .NET(ODP.NET 11.2.0.1.2), due to the fact that Microsoft Oracle Client is deprecated. Ever since the new installation, my SqlDataSource control stopped working. When I try to configure the data source of the SqlDataSource and test the connection, it always gives me the following error message:Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.
OCIEnvCreate failed with return code -1 but error message text was not available. at DataObjectSupport(721,6)
I know for sure the connection settings are definitely correct and the database is online for sure, because any databinding I did manually works perfectly well. I can manually bind to a Gridview, ListBox controls and display the data without any problem. The only problem I have is using the SqlDataSource. This is painful because Gridview and Listview have a lot of cool built-in features. When you databind the controls in the code behind file, you lose all the features.
I have added ASPNET to the Oracle home directory and granted it full control access and retarted the computer but it doesn't work. I'm using Visual Studio 2010 and the database is Oracle 10g. Does anybody know why I'm having problem with SqlDataSource only?
Is it feasible to generate tables(Relational) from XML schema using VS 2008?
View 5 RepliesI have created database in sql server 2005 using Snowflake model.
Problem :
There is 1 fact table and 3 dimension tables.
Suppose Fact Table has cols : sales_person_id, cust_id, product_id and dimension tables as per id s defined in fact table.
Suppose i want to update products in product table, i am able to do so.
but i can not update product_id in Fact Table because remaining two field will be NULL.
I've created a Data Base project with some CLR functions and stored procedures.
I'd like to deploy the assembly under different schema then the default dbo.
Is it possible?
how do i write my alter schema query in Asp.net
using the sqlclient object..
I have the code below:
SqlConnection sqlConnection = new SqlConnection(selectedConnStr);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM " + tableName, sqlConnection);
schema = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection).GetSchemaTable();
Just want to know how can I get the foreign keys from schema?
I am looking for a fast way (either by script or Query statements) that would enable me uniquely extract some tables from my database schema.
The tables I wish to extract have some unique columns like x and y coordinate columns and i want to extract only the tables that have these coulmns in them.
My database schema is very large with 100s of tables that i cant just go through the tables one by one.
I am reading an excel file in C#.NET. The data is being read successfully but there is problem with some hyperlinks stored in the excel file. I can read their text but i dont know how to get the underlying link/url of the column. I couldnt find much help on google as well. if someone has worked in a similar situation please let me know what can be done.edit::: i am using OleDb namespace for establishing a connection with the Excel file so if someone can post a solution which applies to this situation
View 1 Replieshow to read content information from a saved image in SQL image column. I do not want to read the image and display it I know how to do that, what I am trying to accomplish is read the content of that images already saved in the SQL image field, for instance I have a saved image (.JPG, .GIF, PNG, BMP etc) that contains customer demographic information such as (name,address,phone etc) and also contains sensitive data such as (SSN, DOB etc) I just want to retrieve the demographic information and display it on the screen leaving out the sensitive data.
View 1 Replieshave registered keys in the registry for impersonation for my application (asp.net 2.0 running in IIS 7.0)
<identity impersonate="true" userName="registry:HKLMSOFTWAREMY_SECURE_APPAPPNAMEASPNET_SETREG,userName" password="registry:HKLMSOFTWAREMY_SECURE_APPAPPNAMEASPNET_SETREG,password" />
Well it's finally time to stop ignoring my unit's need for reports. I keep coming to dead ends. I gave up the crystal reports idea, and ssrs seems a little easier. Now the problem is that I'm creating a report locally on my laptop, then will change the connection string, upload it to my server and have it run against an identical database on the server.
I'm using SQL Server Express locally, and when I try to create a dataset (using the wizard), I can see the tables, but when I try to add one, I get an error message "Could not retrieve schema information for table or view". I looked up this error and there isn't much useful info on it. I guess it some bug when trying to use SS Express? Is there a work around for this? Can I create the report programmatically? Should I use a different kind of reporting service?
I'm trying to increase the execution timeout and file upload limit on my asp.net website but when i try to add
<httpRuntime
executionTimeout="110"
maxRequestLength="4096">
</httpRuntime>
i get the following errors:
Could not find schema information for the element 'httpruntime'.
Could not find schema information for the element 'executionTimeout'.
Could not find schema information for the element 'maxRequestLength'.
According to this msdn library link this is how I'm supposed to do it,so what am I missing here?
I don't know how to read data into variables from a SELECT query. I can add, update, and delete queries with no issues. I have browsed a few books, but everyone uses a different approach. Suppose I want to to run a query and 1 record is returned. How do I get the values into my variables.
Suppose my table name is "Job Orders", and the row returned has these 3 fields:
JobNumber, FirstName, Lastname
[Code]....
[Code]....
this is where I go blank ?
"I learn by doing, not by reading"
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 RepliesI'm trying to store multiple selected checkboxes from a single checkboxlist, but i don't know where to start. Imagine i have three tables: tbl_events, tbl_organisors and tbl_settings and i want to store the organisors of an event. Each event can have multiple organisors, so each organisor should be added as a single row into tbl_settings. I know how to bind tbl_organisors to a checkboxlist, but how do i store the results (meaning: add the rows to tbl_settings) ?
tbl_events: Event_ID (PK) and Event_Name
tbl_organisors: User_ID and user_name.
tbl_settings: Settings_ID (PK), Event_ID and User_ID
Checkboxlist:
[Code]....
SQLDatasource:
[Code]....
Initially all checkboxes will be unchecked, but users must be able to select multiple organisors from the checkboxlist and then store them into the DB by submitting a form. So the query will look something like: INSERT INTO tbl_settings (user_id, event_id) VALUES (@user_id, @event_id). And this is where my head cracks
1) How do i loop through all selected checkboxes and store each value (user_id) in a new row in tbl_settings?
2) After saving, the users reloads the page and the organisors he just selected must be selected by default in the checkboxlist. How?
The short story is, I'm developing an SSIS package to select from a remote Oracle database (read: no Windows Authentication) and store into an SQL Server db. I can execute the package just fine in development and after importing, but when I run it as a scheduled job, I get an ora-01017 error (bad un/pw). The details are, I built this package and tested in in BIDS but came across the problem that BIDS really doesn't save the password I'd set for the Oracle connection. After poking around a bit, I found this
[URL] which showed how to create an XML configuration which the package could then read. Fiddled around with that, got it working in BIDS. Connected to Integration Services on the server on which I want to run the package, imported it, right-clicked and did the "Run Package" option as a test, it works great. However, when I connect to the same server's Database Engine to create and schedule a job, I cannot connect to Oracle. For some reason, it seems as if the package is not reading the configuration when run in schedule.
I've tried removing the job and re-working it, thinking maybe it didn't pick up the new version when I re-imported the package. A new job had the same problem. Next, I tried re-naming the .dtsConfig and doing the "Run Package" option as a test. Failed with the same error. A bit surprised, I thought I'd get some kind of file error and we wouldn't get as far as trying to talk to Oracle. Anyway, thinking maybe it's permissions on the configuration, fixed the .dtsConfig name and gave full access to Everyone. That ought to let the Agent see it. Scheduled up the job, still can't talk to Oracle. So it seems as if the scheduled version is ignoring the configuration. Anyone have any idea what I'm missing, that scheduling an SSIS package makes it act differently than running it manually? BTW, the instance under which we're running the package is VS 2005. BIDS 2005 to build the package.
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
iam Working on Asp.net Web apliation using c#.net, in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 RepliesI'm Using a DataReader to Read about 100,000 records, my code look like :
[Code]....
I have a per row computation in reading the rows on GetMyType2Info() method, and this method also another method that I return only one record by ExecuteReader(). the problem is that when the MyTypeList (List<T>) has about 21,000 Items of MyType (<T>) System.OutOfMemoryException is thrown. wanted to know how to resolve this and wanted to know more about the maximum size of List<T> capacity. in addition the execution of the main Query with 100,000 records take about 4 seconds in SQLServer a record has only types of nvarchar , float,datetime and int
I have a form with several controls. I'm trying to read from database and navigating through single record per page. I'm displaying a single record but not navigating through. My customerID field is the primarykey. But there are gaps btw records (1,2,5,6,10...etc). Some of them were deleted.
myPage.aspx:
<%@ Page Language="VB" Debug="true" CodeFile="customer.aspx.vb" Inherits="customer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title></title>
<head runat="server">
</head>
<body>
<form id="form1" runat="server">
Customer ID: <asp:Label ID="lblCustomerID" runat="server" ></asp:Label> <br />
Customer Name : <asp:Label ID="lblCustomerName" runat="server" ></asp:Label><br />
<asp:Button ID="btnPrev" runat="server" Text="Prev" OnClick="Prev_OnClick"/>
<asp:Button ID="btnNext" runat="server" Text="Next" OnClick="Next_OnClick"/>
</form>
</body>
</html>
code-behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myReader As SqlDataReader
Dim myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes")
myConnection.Open()
Dim myCommand = New SqlCommand("SELECT * FROM Customers", myConnection)
Dim intFirstRecord As Integer = CInt(myCommand.ExecuteScalar())
myReader = myCommand.ExecuteReader()
If myReader.Read Then
lblCustomerID.Text = myReader("customerID")
lblCustomerName.Text = myReader("CustomerName")
End If
myReader.Close()
myConnection.Close()
currentRecord = lblCustomerID.Text
End Sub
Sub Next_OnClick(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myCommand As SqlCommand
Dim myConnection As SqlConnection
Dim myReader As SqlDataReader
myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes")
myConnection.Open()
myCommand = New SqlCommand("SELECT TOP 1 customerID, CustomerName FROM Customers WHERE customerID > @customerID", myConnection)
myCommand.Parameters.Add("@customerID", SqlDbType.Int, 5).Value = currentRecord
myReader = myCommand.ExecuteReader()
If myReader.Read Then
lblCustomerID.Text = myReader("customerID")
lblCustomerName.Text = myReader("CustomerName")
End If
myReader.Close()
myConnection.Close()
End Sub
I'm being able to read first record. If I click Next button, my page goes to next record for only once. If i click several times, nothing happens. Does not go to next available records.