In my database i have the following table name like
1.xxxx.test1
2.xxxx.test2
3.dbo.test3
4.dbo.test4
5.xxxx.test5
i want to reterive only "dbo.test3,dbo.test4" and need to generate script file for that.it is possible to find only that table.
I got this message while trying to read data from a database table 'Tablename'
Invalid object name 'tableName'
[Code]....
I have the following code:
[Code]....
In this line, I wanted to assign the table to the datatable of dtCA1 and dtCA2.
I need to write this: INSERT INTO tableName DEFAULT VALUES in Linq SQL format, does it possible?
View 6 RepliesI need to create one custom text box control which should be bind with data base.
I am referring following link...
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.databoundcontrol.aspx
I used DataBoundControl to create my control but i am not able to do it properly.
public class SimpleTextBoxControl : DataBoundControl
{
private TextBox nameTextBox;
public string DataTextField
{
get
{
object o = ViewState["DataTextField"];
return ((o == null) ? string.Empty : (string)o);
}
set
{
ViewState["DataTextField"] = value;
}
}
[
Bindable(true),
Category("Data"),
DefaultValue(""),
Description("The text to display on the link."),
Localizable(true),
PersistenceMode(PersistenceMode.InnerDefaultProperty)
]
public virtual string DataTexValue
{
get
{
string s = (string)ViewState["Text"];
return (s == null) ? String.Empty : s;
}
set
{
ViewState["Text"] = value;
}
}
protected override void PerformDataBinding(IEnumerable retrievedData)
{
if (retrievedData == null)
return;
base.PerformDataBinding(retrievedData);
Controls.Clear();
nameTextBox = new TextBox { ID = "nameTextBox" };
foreach (object dataItem in retrievedData)
{
if (DataTextField.Length > 0)
{
nameTextBox.Text = DataBinder.GetPropertyValue(dataItem, DataTextField, null);
}
DataTexValue = nameTextBox.Text;
}
this.Controls.Add(nameTextBox);
}
}
i have a asp.net web with vb code and sql database. i am willing to store the details of the users as ip,computer name and time of using the web is it possible.
View 1 RepliesI'm trying to display images in a GridView (yes, still this...). [edit] Before I can come to that I have to upload some images to the database.
I've followed this tutorial for the "upload image to database" code (this worked fine for uploading images, but I don't know if the images were converted to byte):
[URL]
and I've followed this tutorial for the "display images in gridview" code (and "retrieve file" from the tutorial below).
[URL]
It doesn't quite work, the GridView shows but without images
Now I'm trying to change the "save file" code according to this tutorial:
[URL]
but I don't understand everything in it. When I try to upload an image I get an error on this line:
[Code]....
Basically I've got an update query that runs when you click a submit button. I have an asp:Repeater in my page with a layer inside like this
<asp:Repeater id="dgBookings" runat="server" OnItemDataBound="ItemDB">
<itemtemplate>
<div class="bookingscontent">
<div class="bookingdetails" id="<%# DataBinder.Eval(Container.DataItem, "booking_ref") %>">
<p class="infotext"><%# DataBinder.Eval(Container.DataItem, "adults") %> <asp:LinkButton OnClick="EditDetails" Text="Edit..." runat="server"></asp:LinkButton></p>
<p class="infotext"><asp:LinkButton OnClick="SubmitDetails" Text="Submit..." runat="server"></asp:LinkButton></p>
</div>
</div>
</itemtemplate>
<asp:Repeater>
And it outputs HTML like this
<div class="bookingscontent">
<div class="bookingdetails" id="AL05720">
<p class="infotext">2</p>
<p class="infotext"> <a href="javascript:__doPostBack('dgBookings$ctl00$ctl08','')">Submit...</a></span> <a class="EditAdults" href="#" onclick="return false">Edit...</a></p>
</div>
</div>
<div class="bookingscontent">
<div class="bookingdetails" id="BD45670">
<p class="infotext">4</p>
<p class="infotext"> <a href="javascript:__doPostBack('dgBookings$ctl00$ctl08','')">Submit...</a></span> <a class="EditAdults" href="#" onclick="return false">Edit...</a></p>
</div>
</div>
Basically I need to get the ID of the div where the person has clicked submit and I can't figure out how. I want to put that ID into a string or a session so it can be used in SubmitDetails Sub
I am using ASP.NET Search Form... LikeOrder No. Lorry NoInvoice NoFromToWhen I am enter the Value in the above text fileds... Query will be performed search operation and it will show Serach Result Matched Data's..I am usingfollwing quer
View 17 RepliesI can't see it nowhere in Visual Studio's Solution Explorer. The tutorial that I am following is using the Northwind database and hence the need to add the code line "using NorthWindTableAdatpter;" statement.So I thought I needed to add "using myDBTableAdapters" statement in my code which I did, but it's giving an error saying:
"The type or namespace name 'myDbTableAdapters' could not be found (are you missing a using directive or an assembly reference?)"
What's wrong? Where is the class for myDB's table adapter? I searched the .xsd file, but there's no mention of "myDBTableAdapters".It's not there in the Solution Explorer.
I am want to get data which is inserted or updated today only...and i should be able to copy that data to excel or any other format.
View 2 RepliesI want to change the text of the user name text box which is inside a log in view on selected index chaged event of a drop down list.
this is my code:
[Code]....
but both ddl and tb are null
Anyone knows how can I find the controls in code behind?
i need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database
View 1 Replieshow to find User Mapping option of any database in sql server 2008.
so that i can change the DB_OWNER name to AdMINISTRATOR.
I have to following Linq query, where I look for some different timestamps in an DB:
[Code]....
My problem is that I would like to filter the query, to only return entries, where OutOfOrderStart and OutOfOurderEnd is from the same row. How can I accomplish this?
where can i find the tableadapeter to add data to my database table? and is that the best way or there a easier way... i have a csv file that i would like to add to my data table but i don't know how?
View 1 RepliesI try to create a wordpress site from the gallery and I get an error that says that it cannot find database. I dont have mySQL installed. I thought that WebMatrix would download and install it. Does WebMatrix Beta 3 expect MySQL to be installed? And if so, which version?
View 1 Repliesi am receiving this error when trying to use my membership provider: After googling the error most peoples problems are fixed by removing the old connection string first but this has not worked for me.
I have used a simple custom memberhip provider with one table.
On shared hosting with 123-reg.
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
Source Error:
[Code]....
Stack Trace:
[Code]....
heres my connection strings im using:
[Code]....
In C# I need to connect to a database. How do I find out the username and password to use for that database? I know that sometimes the "sa" username can be used. I don't know how to find the password though. I am working on a contract and no DBA, and the developer left for a different job.
View 1 RepliesI have a very basic web site that uses a standard login control. It was original built using ASP.NET 2.0, and when I preformed a few site improvments, VS 2010 upgraded the site to version 4.0. Locally, everything is fine. But live, everything is working except the login authentication. All other pages that use the database work fine.
does the upgrade process affect the database? As this is the only thing I've not replaced on the live server.
The error I get with the login is:
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file Any thoughts?
I'm using Postgresql/Npgsql in my asp.net application, so I can't use LINQ to SQL. I implemented the following method of User class:
[Code]...
I'm looking for a way to parse excel into Asp.Net, the problem I'm experiencing same as in[ URL]
I've searched all web, but no1 seems to have an answer
here's the error
The Microsoft Jet database engine could not find the object 'Cities'. Make sure the object exists and that you spell its name and the path name correctly.
the code is the exact same as in [URL]
I have a problem that currently we are use a sybase database and we want to create application that give me a output in excel report that's mean my data stored at sybase or mysql and we access it from this after it generate my report in excel form and give this output on excel format?
View 1 RepliesI am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesBy right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies