I created a new database with the help of Database Configuration Assistant !I created with the scott account.Now i'm not able to connect to the database with the connect identifier with the scott account.The error i get is.,
ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.
I've created a connection to a read only Oracle database but when trying to execute a very simple SELECT statement it generates the following error:
"database open for read-only access"
I've tried a datareader and dataadapter so its looking like a specific issue or protocol with the database that I am unaware of.
I am trying to access Mysql database from aspx.pages using a web config file.
My web.config connection string is:
<configuration>
<connectionStrings>
<add connectionString="server-10.xxx.x.xx;uid=xxxxx;pwd=1234;database=Mydb"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
</configuration>
[Code]...
I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..
Here is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EnableModelValidation="True" DataKeyNames="id" >
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
SortExpression="id" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="FATHER_NAME" HeaderText="FATHER_NAME"
SortExpression="FATHER_NAME" />
<asp:BoundField DataField="MOTHER_NAME" HeaderText="MOTHER_NAME"
SortExpression="MOTHER_NAME" />
<asp:BoundField DataField="CLASS" HeaderText="CLASS" SortExpression="CLASS" />
<asp:BoundField DataField="gram" HeaderText="gram" SortExpression="gram" /
<asp:TemplateField HeaderText="Remark" SortExpression="Remark">
<EditItemTemplate>
<asp:DropDownList ID="PS" runat="server" SelectedValue='<%# Bind("Remark") %>'>
<asp:ListItem>PASS</asp:ListItem>
<asp:ListItem>FAIL</asp:ListItem>
<asp:ListItem>APPEARED</asp:ListItem>
<asp:ListItem>NOT APPEARED</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Remark") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
UpDatecommand = "update [REGULAR] set [NAME] = ?, [FATHER_NAME]=?, [MOTHER_NAME]=?, [CLASS]=?, [gram]=?, [Remark]=? where [id] = ?"
SelectCommand="SELECT [id], [NAME], [FATHER_NAME], [MOTHER_NAME], [CLASS], [gram], [Remark] FROM [REGULAR] WHERE (([CLASS] = ?) AND ([SCHCD] = ?))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="class"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="schcd"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 Repliesrecommend a data access class / helper class for Access databases, similar to the sqlhelper class found in the (Data Access Application Block)?
View 6 RepliesIs there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
then the database table is created in database(that is SQL express),how can do that.Please sir help me in that problem.I try that thing and debug the code and there is no error in the code but when I click the button in run time ,no table is created in the database(which is placed in sql express 2005).So my problem is that why the table is not created in the database.
[code]...
My question is that if the user click on button (which is place in default.aspx, for example) then the database table is created in database (SQL express), how can do that? I have tried but errors are occuring during debugging, errors are:the best overloaded method match for 'system.data.odbc.odbc command.odbc command(string,system.data.odbc.odbc connection)'has some invalid arguments.
Argument'2':cannot convert from 'system.data.sqlclient.sqlconnection' to 'system.data.odbc.odbc connection'.
The code written in c# behind the button (button is placed in default.aspx, for example) is:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[code]...
I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?
View 6 Repliesprotected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 RepliesI have a page, Default.aspx, with its own code-behind file like this:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
public int[] anArray;
}
What I'd like to do is access to "anArray" from a C# class (not tied to a page) declared in App_Code folder. What can I do?
Edit: As said in the first comment, I really apreciate your about refactoring my connection objects. However, what I'm really doing here is to rewrite an old PHP application in order to get comfortable with basic C# and ASP.NET, so this code will never go really live. So, I'm still intersted in a way (if any) to access an object declared in a code-behind code from a standard C# class.
Edit2: I removed the OdbcConnection object in order to focus to the real problem: how to refer to an object istantiated in a code-behind file from a C# class situated in App_Code?
i am looking for a source code which will do following operation
1 it will ask user to select txt/csv file only when user click on browse
2 after this when user click on upload it should load all records into existing database table.
I read a lot of tutorials to learn what was the way to manage accessdata on a MySQL database from my ASP.NET, but there still something to whichremains unclear is the formatting of data and the ideal time to do so.For example, if I have a sentence like the following:"Je voudrais t'aider à résoudre ton problème"
When I pass the variable that contains this sentence, I wonder who the quotea problem because the SQL query in this setting look like this:"'I want to help you solve your problem'The quote of "t'aider" comes as the end of ther string in the query string. So I have to the format the string to double the quote to be able to pass it in the database..Maybe I missed the good tutorials, so if you have any links
i am making an asp.net web application.. i wants user to give the facility to login and
View 3 RepliesI have created a .txt file from .net using File.WriteAllText which works fine. Problem is, after being written, I want to grant the file write access so it can be overwritten at some point down the line.
View 3 RepliesI am creating some sessions on successful login and I need to access them from my master page. How do I go about this?
public void showUser()
{
if (!string.IsNullOrEmpty(Session["User"].ToString()))
{
Response.Write(Session["User"].ToString());
}
else
{
Response.Write("Not Logged In");
}
}
My problem is:
I've got a table, dynamically created, fill with a lot of dropdownlists witches IDs are dynamically created.
When a button is pressed, I need to scan all controls in the table and save their value.
But after the postback I can't no longer access to the table.
I have a script which creates a dynamic textbox (and more) in an AJAX async post back. But when I try to acess the textbox I am told "Object reference not set to an instance of an object". I have been strugleing with this for a long time. This is written in C# .Net 4. The line causing the problem is the very last one where I have tbGameName.Text.Trim()
[Code]....
I've a JavaScript function in my page through which i make some elements in the page as 'JQuery UI droppable'.
function setDroppableTargets()
{
$(.cssDockZone).droppable();
}
But the elements with the class cssDockZone is created dynamically upon user interaction. So in the code behind i create the control first and finally at the end i register a scriptblock which calls setDroppableTargets().
//set droppable targets ClientScript.RegisterClientScriptBlock(this.GetType(), "setDroppableTargets", "setDroppableTargets()", true);
But the javascript function is invoked before the controls are created eventhough i register the script at the end (after creating the controls) and i cross checked it by getting the elements with class name '.cssDockZone' and i getting it as 0.
$(.cssDockZone).length
"SELECT a.fibunr, " & _
View 14 RepliesI have a dynamically created address user control (on a customer administration screen) that is created through the use of a place holder. A customer can have multiple addresses, so they dynamically dropped onto the page.
I have got this far, but now I need to be able to save the updated addresses for the customer but I can't get any event to fire on the user controls. When I check to see run plhAddress.HasControls() it returns false?
The way I am generating the user controls is as follows.. private UserControl LoadControl(string UserControlPath, params object[] constructorParameters)
I've created some custom headers for my emails. I've used a breakpoint to see that they are being added to the collection correctly. I don't understand how to access these from the email that's generated though. I'm currently dropping the emails into a pickup directory on my local machine and viewing them with Windows Mail. I have "view all" headers checked in Windows mail but still don't see them when I open my emails in the pick up directory.
how to access the headers that I added? Below is an example of how I did it. I'm hoping to add things like name, address, phone... etc, and then have them visible in the email.
Is this even the correct use of custom headers?
[Code]....
i want to find data from excel sheet using c# my excel sheet like this
Sr. No.
Store Code
Store Name
City
State
1
3062
C.G.Road.
Ahmedabad
Gujarat
2
3103
Iscon Mega Mall 2
Rajkot
Gujarat
3
3113
New Gandhi Nagar
Ghaziabad
Delhi
4........................