Or must it be a SQL Server database? If I'm reading the documentation right, as long as I use Entity Framework and not Linq to SQL, I can go against a Sybase data source. But I'm not certain...
View 1 Replies
I try to connect to database in Adaptive Server Enterprise using Sybase.Data.AseClient dll. Connection string that I am using is 'Data Source='host';Port='5000';UID='user';PWD='password';Database='database';'. When Application tries to connect to database exception is thrown. 'Client can not establish connection'.
I tried connecting to database by trying to create ODBC Data Source. When I try to create DSN using ASE driver. DSN creation also fails.
What should I check ? Do I need to do some settings in database server? I am using all developer editions and my database and application are on the same machine.
I can connect to database Using Sybase Central. I can run queries on same database using Interactive SQL tool.
I want to extract an image from a third party Sybase table which has binary data in it.
To store images they use the following query:
SELECT xp_write_file('C:photo-1.gz', col_name) FROM tbl_name
What I am trying to do is convert the binary data stored to a actual physical file using .Net
I think it is possible, what steps should I go through? And those videos all using Linq as data source, what if I have my own object data source and binding them in code behind, what about it?
View 3 RepliesThe last phase of the installer fails with this message:Installation IncompleteThe installer was interrupted before [project] could be installed. You need to restart the installer to try again.
Running msiexec /i installer.msi /l*vx setup.log shows the following entries in the setup log:
INFO : [...] [ApplyWebFolderProperties]: Getting web folder property token...
INFO : [...] [ApplyWebFolderProperties]: Token is '/LM/W3SVC/1/ROOT/ProjectDir/DynamicData/Filters'.
INFO : [...] [ApplyWebFolderProperties]: Getting METADATA_HANDLE for the directory '/LM/W3SVC/1/ROOT/ProjectDir/DynamicData/Filters'.
[code]...
now the system always prompts a error message about insert duplicate key into Sybase database.how can i prompt a message box instead of this error message when i insert duplicate key into sybase database table. any code can check what type of error then prompt different alert message.
View 1 Repliesdoes anybody have a link to download ODBC DLL connection to a Sybase database?
View 1 RepliesI've a few pages content on a database with a large content.
Should i use a database to store it or try another solution to avoid many connections to database from users? I've thought and XML document but i want to avoid problems with html tags.
About performance, is there better using an database or other solution?
I have already created add/delete rows.. if i click on addRows new rows will be added and when i click DeleteRows the row will be deleted..BUT my question is when new rows are added n the entered data in new rows need to inserted into DAtabase...
View 1 RepliesCan I have scaffolding for tables from more than one table in a single asp.net dynamic data website?? If so, how do you do it?
View 1 RepliesI have a project using vb.net with mySql and mySql.Data.dll as a link to the database. Now when I test my website from local computer and with live server connection string all works fine. The thing is, when I upload my files to the server, it gives me an error Object reference not set to an instance of an object.I have copied the mySql.data.dll file to the bin folder of my domain and the query that gives the error is a basic insert statement that works from the local machine to the live database.
View 1 RepliesRather than having a details button next to the database entry I would like to make a link out of the name field.basically i want the item.Name field to be the name of the link in theHtml.ActionLink(" **here*** ", "Details", new blablalba)What is the syntax to do this in asp.net
View 1 RepliesI have a page which lists stores,malls of individual cities. I have used the list of cities in DropDownList. I have added dynamic title to page as like
Page.Title="Stores in"+DropDownList1.SelectedValue;
It works fine. But when I see that page in Google Search then its showing only one title like "Stores in Delhi". Here 'Delhi' is in the default selected value in DropDownList1. But as I have many cities in that DropDownList1, I want to show each value of DropDownList1 to be appear in search result as title according to search query. For example if user types search query "Stores in Jaipur" then search result should show result with this title "Stores in Jaipur" Remember that Dynamic title is working fine but question is that "How to show is in search result"
I want to upload images in to a folder in my project and save the URL in the database.
When you add a record into my database you provide title, date added and some other details and there it a file upload control which you browser to a image and it saves the image to a folder in my project, it all works, the record is added and the image is uploaded into the folder, but the problem I have is that there is no link from the record to the image, there is no URL path saved in the record. How do I save the image in the folder and save the URL of the image to the record?
I'm using details view to insert the records and using grid view to view the records.
i want to build dynamic sitemap from database..even my menu items are also dynamic...and i want do display sitemap having categories and related menu items from database..
so i dont know how to build dynamic site and create dymanic links of that menus and categories..
I would like to create dynamic fields to search data from Databbase, The interface should be as below:
CustomerID
Example: we have different articles in a database like cars, jewelery, boats. The data related to these articles is different in the tables. I have to show that data in a textboxes and let the user change those data and update. I can do the update and reading the data from database. But the problems is for each item the no.of columns and rows will differ.
My task is I need to get the data according to the use selection in the table with textboxes. I dont know which container (gridview, formview or etc) will suites for my requirement. send me any sample code or any tutorial related to this.
Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))
I am unable to create dynamic menu from database. I have made two tables for this work.First table is Menu which stores menu id and its relevant name.
MId Text
------------
1 File
2 Edit
3 View
..
..
Second table is subMenu which stores submenus which will be linked to the menu table with menu id.
SId Text MID
-------------------
1 New 1
2 Open 1
3 Save 1
4 Cut 2
5 Copy 2
the menu should be created dynamically from the database, each menu should be displayed in single row
when we click on a menu the submenus are displayed in rows that in expand & contrast form
how to design & develope this page
i have read and used this script.Adding Dynamic Rows in ASP.Net GridView Control with TextBoxes..it is very usful to me but i want to fetch data from sqll database and fill the newest row with it. the past row data hav to be remain same. becoz of the same name of textbox it happens. whenever i try to fetch data from database and fill textbox all rows get updated with the same data.
View 1 RepliesHere is my .aspx page
<asp:Repeater ID="Repeater1" runat="server"> <HeaderTemplate> <tr bgcolor="maroon"> <th>
Subject Id </th> <th>
Subject Name </th> <th>
Obtained Marks </th> </tr>
</HeaderTemplate> <ItemTemplate>
[Code] .....
c# - code behind
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
this.PopulateRepeater();
} } private void PopulateRepeater() {
[Code] .....
Current repeater looks as...
Subject_Id Subject_Name Marks
s1(lable) subject1(lable) 56(textbox)
> Now, I want to make Updation with repeater (in same application).
I want to update Marks(into textboxes only, sub_id and name fatched from database dynamically) in each row of repeater.... how is it possible ??
I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best alternative? Data transmission Service(DTS)?
View 1 RepliesI have used this gridview in my project nad its working fine.
View 2 RepliesI have a page with a data repeater. Each row has a dropdownlist for the user to select a value and the values in every dropdown are the same. I also have an SqlDataSource which each dropdownlist gets its values from as its created. Everything is working as it should but for each dropdown that is rendered a seperate call is made to the database.
suggest a better way for me to do this that means only one call to the database for all dropdowns rendered?
I am using this reference to make some application .. In this article we can only save with varchar data types
So how to use some other data types like datetime, money, int..or how to use parameters to convert data.
[URL] ....
As that title says my aspx page shows a compile error on the @Page directive that says "ASP.NET runtime error: Cannot load file or Assembly 'Microsoft.SqlServer.BatchParser' or one of it's dependencies". The project compiles with our error and it runs with no problem. The only real problem that this causes it that the intellisense for anything other than simple HTML is broken so I can't type asp:Controlname and have intellisense show me a the list of items or properties in a control. I get a green squiggly line under all the asp tags saying "Unrecognized tag prefix or device filter 'asp'". This project doesn't directly use SQL SMO but it does reference a project that does. However, I removed that reference and the problem still doesn't go away. I have installed on my development machine the full SQL client and for both SQL 2005 and 2008 (including the SDK) from the Developer editions of both versions. This was not a problem on VS2005 and the project compiles without error in VS2010 too.
View 1 Replies
