|
|
oh yeah, but some days ago when i used Restart() then it created new instance but didnt close the current running app, so to do that i used Exit()
Becoming Programmer...
|
|
|
|
|
hi
I am creating travels project, in left part of my datagrid of my default page i placed all the products such as india tour ,world tour etc and if v click any product it will redirect to itennary page according to their ID's
my problem is if i added new product such as Hotel Booking in the datagrid and after clicking it then i want to place textbox and a button in the itenary page and if v click india tour or world tour i want those textbox and button should be not visible
Please try to solve my problem,its very urgent
thankn you in advance
raghu
hi
i want to populate country's name in 1st dropdownlist and their states should be placed in the 2nd dropdownlist, if we select any state it should place the name of the capital in the textbox besides that and so on.....
If possible send me code
thank you in advance
raghu
|
|
|
|
|
Refer this link Google[^]
raghu.chanti wrote: hi
i want to populate country's name in 1st dropdownlist and their states should be placed in the 2nd dropdownlist, if we select any state it should place the name of the capital in the textbox besides that and so on.....
If possible send me code
Your signature looks awkward 
Sathy
|
|
|
|
|
Hello Friends,
I am developing an windows application in C#.NET.
I want to make text box multilingual means it can take input in any language..
|
|
|
|
|
Hey all
i have a little promblem with a dataGridView, let me explain the scenario
in my db i have a table (timeCategories) that references its self. for example
(i put dashes cuz the page takes out white space automaticly)
[TimeCatID]-[TimeCatName]-[TimeCatRate]-[Normal]-[AlternateTimeCat]
[0]---------[NormalTime]-----[1.0]---------[1]------[1]
[1]---------[OverTime1.5]----[1.5]---------[0]------[1]
the alternate time category references the TimeCatId in the same table so the alternate time category for Normal Time would be OverTime1.5
now the problem is this, in my app i have a DataGridView that Displays the data of this table, but the AlternateTimeCat column has to be a DataGridViewComboBoxCell that is databound to the same table's TimeCatID (valueMember) and TimeCatName(dsiplayMember)
I found some articles the cover DataGridViewComboBoxCell but in the new DataGridViewComboBoxCell.items are added programmaticly
can someone plz help or point me in a direction
thanx!
Harvey Saayman
Think big and kick ass
|
|
|
|
|
i want to work in c# with opengl. but here is a problem which i have found. from nehe website i have read that install sdl and then add dll of system, tao.opengl, sdldotnet, tao.windows.form. but when i run the example of nehe website. it threws an exception of video that type initialization exception.
if anyone knows that kindly reply me.
|
|
|
|
|
If you don't tell us the exact exception and message, then how should we be able to help you?
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Why not raise this on the nehe forums? It sounds like the type of thing that they should be able to deal with.
|
|
|
|
|
Hello Friends,
I am developing an windows application in C#.NET using SQL Server 2000. As i have several form in my application and i have to declare connection string on each form. Now i want that connection string once declared used in whole project.
So please help me in declaring connection string once for whole project and that connection string can be accessed on each form of my application.
Thanks
|
|
|
|
|
Put it in app.config file.
|
|
|
|
|
<br />
<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using System.Data;<br />
using System.Data.OleDb;<br />
<br />
public class mdGlobal<br />
{<br />
string ConnectionString = "Provider=Microsoft.jet.oledb.4.0;data source=" + DatabasePath + " ;Jet OLEDB:Database Password=123";<br />
OleDbConnection con;<br />
OleDbCommand Com;<br />
OleDbDataAdapter da;<br />
<br />
public object ExecuteScaler(string MyQuery)<br />
{<br />
try {<br />
con = new OleDbConnection(ConnectionString);<br />
Com = new OleDbCommand(MyQuery, con);<br />
con.Open();<br />
object result = Com.ExecuteScalar;<br />
con.Close();<br />
return result;<br />
}<br />
catch (Exception ex) {<br />
mdChecking.Prompt(ex.Message.ToString);<br />
if (con.State == ConnectionState.Open) {<br />
con.Close();<br />
}<br />
}<br />
<br />
}<br />
<br />
public void ExecuteQuery(string MyQuery)<br />
{<br />
try {<br />
con = new OleDbConnection(ConnectionString);<br />
Com = new OleDbCommand(MyQuery, con);<br />
con.Open();<br />
Com.ExecuteNonQuery();<br />
con.Close();<br />
}<br />
catch (Exception ex) {<br />
mdChecking.Prompt(ex.Message.ToString);<br />
if (con.State == ConnectionState.Open) {<br />
con.Close();<br />
}<br />
}<br />
<br />
}<br />
<br />
public DataSet GetResultFromQuery(string MyQuery)<br />
{<br />
try {<br />
DataSet ds;<br />
con = new OleDbConnection(ConnectionString);<br />
da = new OleDbDataAdapter(MyQuery, con);<br />
ds = new DataSet();<br />
con.Open();<br />
da.Fill(ds);<br />
con.Close();<br />
return ds;<br />
}<br />
catch (Exception ex) {<br />
mdChecking.Prompt(ex.Message.ToString);<br />
if (con.State == ConnectionState.Open) {<br />
con.Close();<br />
}<br />
}<br />
<br />
}<br />
<br />
public long ReturnSingleValue(string MyQuery)<br />
{<br />
try {<br />
DataSet ds;<br />
long result;<br />
con = new OleDbConnection(ConnectionString);<br />
da = new OleDbDataAdapter(MyQuery, con);<br />
ds = new DataSet();<br />
con.Open();<br />
da.Fill(ds);<br />
if (ds.Tables(0).Rows.Count > 0) {<br />
if (!Information.IsDBNull(ds.Tables(0).Rows(0).Item(0))) {<br />
result = (long)ds.Tables(0).Rows(0).Item(0);<br />
}<br />
else {<br />
result = -1;<br />
}<br />
}<br />
else {<br />
result = -1;<br />
}<br />
con.Close();<br />
return result;<br />
}<br />
catch (Exception ex) {<br />
mdChecking.Prompt(ex.Message.ToString);<br />
if (con.State == ConnectionState.Open) {<br />
con.Close();<br />
}<br />
}<br />
<br />
}<br />
<br />
}<br />
<br />
<br />
chane above code according to you requirement and use it.
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
... or you could pass it as a parameter to any form .ctor
SkyWalker
|
|
|
|
|
yes Mircea Puiu has the right sollution
if u make a new connection every time u want to get data from a database you cause unnecicary overhead and lag when you are opening the window (assuming u make the connection OnFormLoad)
what you sould be doing is making a connection when the program starts up in the Main() method
then when you open a new window u send the instance of the dataBaseConnection to that form
<br />
static class Program<br />
{<br />
[STAThread]<br />
static void Main()<br />
{<br />
Application.EnableVisualStyles();<br />
Application.SetCompatibleTextRenderingDefault(false);<br />
<br />
string ConnString = @"User id = ***; Password = ***; Initial Catalog = ***;<br />
Data Source = ***";<br />
<br />
SqlConnection sqlConn = new SqlConnection(ConnString);<br />
<br />
Application.Run(new FrmMain(userClass, sqlConn));<br />
}<br />
}<br />
now u hav to catch that object in the mainform and you will do this in the constructor of the main form
<br />
public partial class FrmMain : Form<br />
{<br />
SqlConnection sqlConn;<br />
<br />
public FrmMain(SqlConnection sqlCon)<br />
{<br />
InitializeComponent();<br />
sqlConn = sqlCon;<br />
}<br />
}<br />
the reason why i hav declared another SQlConnection object is because of scope, when sqlCon comes in to the FrmMain constructor it is only accessable there. so what we did was create a "blank" sqlConnection and set the one with class wide scope = to the one with only constructor wide scope!
this eliminates the need to make a seperate connection each and every time u need to gat data and it doesnt lag a bit!
hope this helped!
Think big and kick ass
modified on Tuesday, February 12, 2008 4:57 AM
|
|
|
|
|
HarveySaayman wrote: if u make a new connection every time u want to get data from a database you cause unnecicary overhead and lag when you are opening the window (assuming u make the connection OnFormLoad)
what you sould be doing is making a connection when the program starts up in the Main() method
then when you open a new window u send the instance of the dataBaseConnection to that form
 Tell me you're joking. Please.
This is the worst thing that you could do. When you do this, you have opened a persistent connection to the database which doesn't get closed until your application exits. This means that your application isn't scalable. More importantly, it doesn't cater for the fact that the database may go down and come back up between calls. If this happens, then your connection is no longer valid.
The general rule is acquire a connection as late as possible and release it as early as possible because a connection is a "precious" resource. If you have pooling enabled, then new connections will merely pull the connection from the pool (dependent on the connection string you pass in).
The correct way to do this (from .NET 2 on) is to put an entry in the ConnectionStrings section in the config file. Then use ConfigurationManager.ConnectionStrings["ConnectionStringNameHere"].ConnectionString to retrieve the actual connection string.
|
|
|
|
|
hi peepZ
after doing some more research on this topic ive stumbled upon something... i use DataAdapters all through my app.
so let me quote a paragraph in "PRO C# 2008 and the .NET 3.5 platform" page 784 Chapter 23 (incase anyone has this book)
"The data adapter object of your data provider handles the database connections automaticly. In an atempt to increase scalability, data adapters keep the connection open for the shortest amount of time posible.
once the caller receives the DataSet object, the calling tier is compleatly disconected from the database and left with a local copy of the remote data. The caller is free to insert, delete or update rows from a given DataTable, but the physical database is not updated until the caller explicitly passes the DataSet to the dataAdapter for updating. in a nutshell, the datasets allow the clients to pretend they are indeed always connected, when infact the are operating on an in memory database"
having read this there is nothing wrong with passing a SqlConnection between forms because i never actualy do SqlConnection.Open() i just pass the closed connection to the dataAdapter which then manages the connections for me
therefore i dont see a problem? i might be wrong, like i said im just a rookie!
i did how ever use the app.Config file to save my connection string but i only use this once in Main().
the problem i hav with making a new connection every time u need data from the db is LAG. its takes a noticeable amount of time to open forms and all the forms in my app query the database before frmWhatEver.Show() is called.
thanx
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
|
|
|
|
|
Are you out of your mind? 
Pete is correct. This IS the worst thing you can do. Do you know how expensive an SQL Server connection license is?? Hogging it for the life of your application, which BTW won't do anything with it for about 95% of the time the app is open, is a VERY expensive way to run an app and waste resources on the SQL Server.
|
|
|
|
|
The correct way to do this (from .NET 2 on) is to put an entry in the ConnectionStrings section in the config file. Then use ConfigurationManager.ConnectionStrings["ConnectionStringNameHere"].ConnectionString to retrieve the actual connection string. If you want one entry (and one entry only) then use a static string to store this:
public static class Utility
{
private static string _connString = string.Empty;
public static ConnectionString
{
if (_connString == null)
{
_connString = ConfigurationManager.ConnectionStrings["..."].ConnectionString;
}
return _connString;
}
}It's now available wherever you need it, e.g.
using (SqlConnection conn = new SqlConnection(Utility.ConnectionString))
{
}
|
|
|
|
|
Thanks you
Its works great
Regards
Dikshant Tyagi
|
|
|
|
|
hey!
i guess that why im just a junior? 
anywho, i never actualy thaught what would happen if the connection dropped! im such an idiot! but hey, im learning.
ok so i added the app.config file to my project and im using (using System.Configuration; ). but i cant get to ConfigurationManager? why not? or am i just being a no0b again?
oh and why no return type for ConnectionString? im assuming its a method aswell
thanx for showing me the error in my ways!
Think big and kick ass
|
|
|
|
|
Hi Guy
This is very simple. right click in ur main project. and add Application Configuration file.after add with with Configuration tag type like this
<connectionstrings>
After create a stati common class .with in that class
static string conString=ConfigurationManager.ConnectionStrings.
that's all
Use every where in ur project.
see this for more
http://msdn2.microsoft.com/en-us/library/ms254494.aspx[^]
Thanks
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
Hi ALL,
I need to add a hindi font in my set up project(C#) so that client does not need to install that font seprately. So should I add that font in my project. I copied that font in my setup but it simply get copied to the target machine but doesnot get install itself. Please let me know how could I do this so that it get automatically installed in windows font folder.
Thanks a lot
Bajrang Singh
Using .net 2.0 (VS2005)
|
|
|
|
|
hi,
before some time ago , i face this problem. i find the net to resolve this problem and find solution which i decribe below. Note that following code is in vb.net so convert it in c#
first of all add this font to your application for example "ITCKRIST.TTF"
now imports following namespace in module or form level
Imports System.Drawing<br />
Imports System.Text<br />
Imports System.Collections.Generic<br />
Imports System.ComponentModel<br />
now call the following API as following
Private Declare Auto Function AddFontMemResourceEx Lib "Gdi32.dll" _<br />
(ByVal pbFont As IntPtr, ByVal cbFont As Integer, _<br />
ByVal pdv As Integer, ByRef pcFonts As Integer) As IntPtr<br />
now write a function as following
Public Function GetFont(ByVal FontResource() As String) As _<br />
Drawing.Text.PrivateFontCollection<br />
'Get the namespace of the application <br />
Dim NameSpc As String = _<br />
Reflection.Assembly.GetExecutingAssembly().GetName().Name.ToString()<br />
Dim FntStrm As IO.Stream<br />
Dim FntFC As New Drawing.Text.PrivateFontCollection()<br />
Dim i As Integer<br />
For i = 0 To FontResource.GetUpperBound(0)<br />
'Get the resource stream area where the font is located<br />
FntStrm = _<br />
Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream( _<br />
NameSpc + "." + FontResource(i))<br />
'Load the font off the stream into a byte array<br />
Dim ByteStrm(CType(FntStrm.Length, Integer)) As Byte<br />
FntStrm.Read(ByteStrm, 0, Int(CType(FntStrm.Length, Integer)))<br />
'Allocate some memory on the global heap<br />
Dim FntPtr As IntPtr = _<br />
Runtime.InteropServices.Marshal.AllocHGlobal( _<br />
Runtime.InteropServices.Marshal.SizeOf(GetType(Byte)) * _<br />
ByteStrm.Length)<br />
'Copy the byte array holding the font into the allocated memory.<br />
Runtime.InteropServices.Marshal.Copy(ByteStrm, 0, _<br />
FntPtr, ByteStrm.Length)<br />
'Add the font to the PrivateFontCollection<br />
FntFC.AddMemoryFont(FntPtr, ByteStrm.Length)<br />
Dim pcFonts As Int32<br />
pcFonts = 1<br />
AddFontMemResourceEx(FntPtr, ByteStrm.Length, 0, pcFonts)<br />
'Free the memory<br />
Runtime.InteropServices.Marshal.FreeHGlobal(FntPtr)<br />
Next<br />
Return FntFC<br />
End Function<br />
<br />
almost work is done . Now you can change font of any control. for example
dim strFont(0) As String<br />
dim FntFC As New Drawing.Text.PrivateFontCollection()<br />
<br />
strFont(0) = "ITCKRIST.TTF"<br />
FntFC = GetFont(strFont)<br />
<br />
Label1.Font = New Font(FntFC.Families(0), 16)<br />
Label2.Font = New Font(FntFC.Families(0), 16)<br />
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
In the setup program click add special folder and choose Fonts Folder. Add your font to that folder. The font will be automatically installed and uninstalled together with your program
|
|
|
|
|
hi Giorgi,
your solution is better from my solution.
difference is that my solution is work for specific application ,not for all.
thanks
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
