|
<connnectionstrings>
<add name="Connection" connectionstring="">Data Source=***;Initial Catalog=***;User ID=*** password=***" providerName="***">
<connectionstrings>
does anyone know what exactly i have to put as the attribute values where i have put ***'s on.
i have created a sql server database through asp.net 2.0 i have a table called files
and i'm also using the membership provider.
can anyone help me to fill the highlight attributes correctly.
please!!!
|
|
|
|
|
This site[^] contains examples of connection strings.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Data Source= Server Name on which Database is stored.
I think u are not using a remote server...the value will be
Data Source= localhost or localhost\(name of SQL server)
Initial Catalog=DATABASE_NAME;
User ID=***
password=***"
providerName="System.Data.SqlClient" (for MS SQL SERVER)
|
|
|
|
|
In my web.config, I have this connection string:
<add name="ExcelConnection" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Documents and Settings\Steven\My Documents\example.xls;Extended Properties=Excel 8.0"/>
In my code file, I have this code to open the connection, and put the data in a Grid View control.
string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["ExcelConnection"].ToString();
OleDbConnection conn = new OleDbConnection(connstr);
string strSQL = "SELECT * FROM [Time$]";
conn.Open();
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();
When I try to run it, it gives me this error:
The Microsoft Jet database engine could not find the object 'Time$'. Make sure the object exists and that you spell its name and the path name correctly.
Everything looks fine to me, does anyone know what the problem is?
|
|
|
|
|
Dude, I'm guessing that Time$ does not exist.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
It does exist, the name of the sheet in my excel file is "Time". Everywhere I've looked, it says to reference the sheet by: [SheetName$].
|
|
|
|
|
A few thoughts:
Check your path.
Don't use reserved words as your sheet name. Try "TheTime" or something instead.
I think you need to provide escaped quotes in the "Extended Properties" part of your connection string.
I.E.
<add name="ExcelConnection" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Documents and Settings\Steven\My Documents\example.xls;Extended Properties=""Excel 8.0"""/><br />
|
|
|
|
|
Hy!
I've found that GridView has a property: AllowSorting which can be true or false, but I didn't find out how to sort a column's information just by pressing the column header and nothing else.
I'm still looking for this, but i'm little hurry rigth now!
Thanks!
|
|
|
|
|
SortExpression="DatabaseColumnName"
think this will work
|
|
|
|
|
Thanks!
I'll try and tell the result.
|
|
|
|
|
There is a problem with the column header. Although i have set the AllowSorting with the true value I can't click the column's header.
|
|
|
|
|
Hi! I have one issue and I am sure that many guys here know how to help me. I am building a web application in ASP.NET with C#, and now I have a dropdownlist connected to the field in the database, and I have a label, and I want to display other value from the database there. Like, I am selecting my name in the dropdown list, and in the label it should display my second name. Thanks ahead
|
|
|
|
|
1. Select the data from the database
2. put in dataset or some sort of source
3. string value = some sort of source
4. label.text = string
something like that
|
|
|
|
|
that's ok, but I want to make like if the username is selected, then display the password in the label from the same table, and how should I make that statement. Thx
|
|
|
|
|
use an onclick for when the username is selected
public onclick
set username selected as string value
stusername = ddusername
select password from table where username = '" stusername"'
that help?
|
|
|
|
|
hi to everyone! I have this problem, when I want to bind a data to label, i am going with:
Label1.Databindings.Add("Text", dataset1, "informations.username");
and i get this mistake:System.Web.UI.WebControls.Label' does not contain a definition for 'Databindings'
Any help? Thanks
|
|
|
|
|
textBox1.DataBindings.Add(new Binding("Text", dataset1, "informations.username"));
Try This It will work
|
|
|
|
|
Hi everybody.
I have this porcion and i want ,from the onclick event, to get a simple string that is in the first column of the clicked row, in the gridview
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Attributes["OnClick"] = ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex.ToString();
string thefistvalue = <---- what i write here?
}
please help me.
thanks
|
|
|
|
|
do you mean something like
GridView.DataKeys[i].Values[i].ToString();
set datakeys as one of the values you want
this might help
|
|
|
|
|
thank you a-+s-+p-+
wath is this "i"?
is int i = GrieView.SelectedIndex; ?
this give me index out of range.
|
|
|
|
|
the i that i've used is in a for statement, its up to you how you write the format of it
|
|
|
|
|
need help
Hi quys,I stored a pdf file in database.. I want to open that pdf file in a IFrame...
please help
|
|
|
|
|
did the article i posted not help
please avoid re-posting your messages
|
|
|
|
|
You just need to stream it by using REsponse.BinaryWrite and setting the contentType appropriately.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
please help..
Any one know how to open doc, excel and pdf files in iframe using asp.net
|
|
|
|