|
1.go to Tools and click connect to database.
2.enter the server name ex in default .\sqlexpress and enter the new database name.
3.and press ok.
IN aspx.cs write this coding.. and add using System.Data.Sqlclient
SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=Databasename;Integrated Security=True");
con.Open();
|
|
|
|
|
What are the benefits of using of ADO.NET in .NET 4.0.
|
|
|
|
|
See here[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
1.processing speed increase
2.connection mode is steady
3.Using different innovative idea to display data
|
|
|
|
|
HI all,
in my application i am using infragistics webdatagrid.when i want to edit the selected row i am using edit template.
after click on ok button how to retrive the control values from edit template of the webdatagrid.
Please help me
Thanks
|
|
|
|
|
If you did not got how to do it from Infragistics help documents, i would suggest you to have a look/post here: Infragistics Forum[^]
3rd parthy control specific forums help more in such queries.
|
|
|
|
|
Hello,
I have a web portal with traditional webpages.
This website is enabled with multiple languages and translated text is saved/retreived from database.Website works with all languages in all pages except one page for French language.
When I click the buttons(only when current language is Fech ) in that particular page-->form's postback event is fired but no button click event.
Can somebody help me with this problem.
|
|
|
|
|
Inspect the page_load "sender" object in quickwatch and see if the button is missing.
Also, check the viewstate of the page.
Another probable reason could be validation request. As you gave choose culture french, there could be a possibility of having characters that are recognized as potential dangerous to restrict cross scripting attack.
Hope this helps.
cheers
"We know accurately only when we know little. With knowledge, doubt increases.”
|
|
|
|
|
Hi, i need to open HTML file into pdf. i'm creating HTML file using String Builder then i will convert that into PDF using HTMLWorker, PDF writer. Here i can open file from my local but once i open from server then i can't open its showing pdf file was demaged.
Here is my code to convert pdf
//Pdfbuilder is string builder
string strPdfContent = Pdfbuilder.ToString();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=AboDetails.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringReader reader = new StringReader(strPdfContent);
Document doc = new Document(PageSize.A4, 10, 10, 0, 0);
HTMLWorker parser = new HTMLWorker(doc);
PdfWriter.GetInstance(doc, Response.OutputStream);
//PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(AboDetails.pdf, FileMode.Create));
doc.Open();
try
{
parser.Parse(reader);
Response.Write(doc);
Response.End();
}
catch (Exception ex)
{
}
finally
{
doc.Close();
}
Please its very urgent. If anyone knows the solutions please help me.
awaiting for your reply.
Regards,
Vinothini Dharmaraj.
|
|
|
|
|
vinothini dharmaraj wrote: Please its very urgent.
No, it's not. This is a free service, and you can't rush charity. If your planning did not include research, I suggest you review your planning.
FWIW; you first want to know whether the file is generated correctly, or not. If it is, then there's a problem in the transfer, or the viewer - otherwise you could quickly try another PDF-generator.
Easiest way to determine is by generating the PDF on the server, copying the PDF by hand, and try to open it on different computers with different viewers (I use both the Adobe-reader and the Foxit reader to verify) Also try to find out the version of the PDF file being generated.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi every one.
I have copying my database via setup to Program File of customer system.
now how can i give the conection string that can attach the DB (in webconfig):
<connectionStrings>
<add name="SqlConnStr" connectionString="Data Source=.\CMSNegin;AttachDbFilename=%programfiles%\TSMS.mdf;Initial Catalog=NeginDB;uid=sa;pwd=u1$%^ggrf0923" providerName="System.Data.SqlClient"/>
</connectionStrings>
I have used "%ProgramFiles%" but no use...
Please Help
Thanks in Advanced !
modified 1-Oct-12 6:40am.
|
|
|
|
|
<connectionStrings>
<add name="SqlConnStr" connectionString="Data Source=.\CMSNegin;AttachDbFilename=<code>%programfiles%</code>\TSMS.mdf;Initial Catalog=NeginDB;uid=sa;pwd=u1$%^ggrf0923" providerName="System.Data.SqlClient"/>
</connectionStrings>
|
|
|
|
|
what ?
modified 1-Oct-12 7:05am.
|
|
|
|
|
If you use values like this in your connection string then i think you will need to modify it at execution time in order to replace the %programfiles% with the real path. See Web.config File - ASP.NET[^] for some useful information on the web.config file.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Thanks for solution but i didnt get anything..plz give an example how to do that.
Thanks in advanced
|
|
|
|
|
You need to spend some time getting familiar with MSDN, which contains documentation for just about everything you will ever need, including this section on environment variables[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Why have you created a new CodeProject id for this?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
It was mistake that i create two id...
How can i use Environment.ExpandEnvironmentVariables in web.config for connectionstring?
Thanks in advanced!
|
|
|
|
|
Member 9473809 wrote: It was mistake that i create two id...
Then please post a message here[^] to ask the administrators to remove the duplicate.
Member 9473809 wrote: How can i use Environment.ExpandEnvironmentVariables
The link to the documentation that I posted contains a code sample, I cannot offer anything that is clearer than that.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Thanks !
But i didnt find the solution. Isn't there anybody to do that !
|
|
|
|
|
You have the solution, it's just that you need to to spend some time modifying it so it suits your specific problem.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
thanks
i dont know the solution .
Help! if possible give example!
|
|
|
|
|
jojoba2011 wrote: i dont know the solution .Help! if possible give example!
There is really no point in you repeatedly posting the same cry. I have given you a link to the method you need to use, which includes a code sample which demonstrates exactly how it can be used to expand an environment variable in a string. Unless you give some more details about how exactly you are trying to use it and why it does not work, then it is unlikely that we can guess what your problem is.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi sir,
this is exactly what i wanna to use in webconfig:
<connectionStrings>
<add name="SqlConnStr" connectionString="Data Source=.\CMSNegin;AttachDbFilename=%ProgramFiles%\CMSNegin\Data\MSSQL10.CMSNegin\MSSQL\DATA\1\NeginDB.mdf;uid=sa;pwd=A@D#F$G%" providerName="System.Data.SqlClient"/>
</connectionStrings>
i dont know which drive is system drive (C or D).cause my setup copies the database to %programfiles% .
may be C:\program files OR D:\Program files.
modified 2-Oct-12 12:51pm.
|
|
|
|
|
I still don't understand what your problem is. If you follow the documentation in the link I gave you[^], it shows exactly how to get the real path from an environment variable, including the system drive. What more do you need?
One of these days I'm going to think of a really clever signature.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
