|
Hello Everybody,
In my application connection string is below and the database working on another computer.
Unfortunately I couldn't connect it. What could be the problem? (I checked the IP number and it is correct. Also I could connect local database). I tried some other connection strings but none of them could connect.
Thanks a lot.
SqlConnection conn = new SqlConnection(("Data Source=10.11.11.126;Initial Catalog=northwind;Integrated Security=SSPI"));
|
|
|
|
|
What's the error you got? Is this ASP.NET code, or in some WinForm app?
You're probably dealing with an authentication error: the user that the code is running as doesn't have login rights to the server.
|
|
|
|
|
try adding userid and password , if that dont work also try name="That comp name"
If only they could see what I see in my mind
|
|
|
|
|
try adding userid and password of the comp u r trying to connect to, if that dont work also try name="That comp name".
If only they could see what I see in my mind
|
|
|
|
|
I solved it. I used a winform. After I added my user name (Windows authentication) I could connect. However if I use the same connection string which is below I couldn't connect in Asp application. Is there any idea?
Thanks.
SqlConnection conn = new SqlConnection(("Data Source=10.11.11.133;Initial Catalog=northwind;Integrated Security=SSPI"));
|
|
|
|
|
Read XML as Dataset and Populate it into treeview.
|
|
|
|
|
All your posts over the last week have either been "Urgent" or "Very Urgent". Operating in this sort of crisis mode all the time is not good for your health.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Like this?
DataSet DS = new DataSet();
// to read
DS.ReadXml(@"Path"); // reads the XML to the dataset
// to write
DS.WriteXml(@"Path"); // Saves the dataset to XML
|
|
|
|
|
|
What's with all the 5 word questions? If you can't invest the time to explain your delima, why should anybody take the time to respond?
Visit BoneSoft.com
|
|
|
|
|
Wooooow boy. Don't you sound like M? (The lady who orders James bond around?).
Like when M calls James on a private line and just got time to deliver a 1 line message: "Urgent, Flying eagles are gettinng closer to Jumping Frogs"
Listen buddy: If you don't try out some stuff on your own, you cannot survive eating on posts and forums. You seem to be exactly that kind of parasite who sucks but never gives. Next time try such a catchy title, and see how the community of back-savers gets back at you.
Koushik Biswas
|
|
|
|
|
Hi freinds,
How to set default document in IIS 6.0 from commandline.
It can be set from IIS manager but I need to run it with cscript.exe.
Is there any way to do this with IISVdir.vbs or IISWeb.vbs or any other way
Regards
Bhaskar
-- modified at 5:34 Thursday 8th June, 2006
|
|
|
|
|
please post me , how i could change font size or style or ... of a specified item from listbox in win app VS2003 ?!
Thanks
Salmani
-- modified at 5:05 Thursday 8th June, 2006
|
|
|
|
|
You can set the color of individual items in a ListBox using C# in your .NET WinForm by writing your own handler for the listbox's DrawItem event.
Set the ListBox's DrawMode property:
Add a standard ListBox to your .NET WinForm then set it's DrawMode property to OwnerDrawFixed which forces the ListBox's DrawItem event to be fired.
Write the handler for the DrawItem event:
private void lstBox_DrawItem(object sender, System.Windows.Forms.DrawItemEventArgs e)
{
//
// Draw the background of the ListBox control for each item.
// Create a new Brush and initialize to a Black colored brush by default.
//
e.DrawBackground();
Brush myBrush = Brushes.Black;
//
// Determine the color of the brush to draw each item based on
// the index of the item to draw.
//
switch (e.Index)
{
case 0:
myBrush = Brushes.Red;
break;
case 1:
myBrush = Brushes.Orange;
break;
case 2:
myBrush = Brushes.Purple;
break;
}
//
// Draw the current item text based on the current Font and the custom brush settings.
//
e.Graphics.DrawString(((ListBox)sender).Items[e.Index].ToString(),
e.Font, myBrush,e.Bounds,StringFormat.GenericDefault);
//
// If the ListBox has focus, draw a focus rectangle around the selected item.
//
e.DrawFocusRectangle();
}
In the InitializeComponent section associate your handler to the DrawItem event:
this.lstBox.DrawItem += new System.Windows.Forms.DrawItemEventHandler(this.lstBox_DrawItem);
|
|
|
|
|
Hi,
Need Help Please!
Appearing Error Message: "Object reference not set to an instance of an object", while pointing to dgvInventoryItems.
Problem 1)
Despite of Checks, this message come when i click on the empty (last) row of the DataGridView which is binded with the DataTable.
if (this.dgvInventoryItems.CurrentRow != null )<br />
{<br />
this.tbItemNrEdit.Text = this.dgvInventoryItems.Rows[index].Cells["ItemNr"].Value.ToString();<br />
....... }
Problem 2)
The same message again appear when trying to get value from the cell of a non-binded DataGridView. This time it has a string value, but again its generating the above mentioned error message.
Trying to get value from the cell in CellLeave event of the grid.
here is the code.
private void dgvNewInventory_CellLeave(object sender, DataGridViewCellEventArgs e)<br />
{<br />
long id=333; string strval;<br />
strval = this.dgvNewInventory.Rows[e.RowIndex].Cells[0].Value.ToString();
dgvNewInventory.Rows[e.RowIndex].Cells[1].Value = id;
}
Where i'm making mistak.
Thanks.
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
Hello, can please somebody write me a program(code)in C/C++ wich will count how many years is in one century.... it is urgent, thanks for your help.  
|
|
|
|
|
I thought that in one centruy there is 15 years no?
or was it 150? or 100?
1. Why do you need it if you know that in ONE century there is 100 yrs (1900-2000 - not including 2000 including the 0 is 100.)
2. This is C# forum, not C/C++... go to the correct forum please.
3. Topic - not realy good, add 3 more ! to even it up next time. (or just read the first pinned topic by the admin: "How to get an answer to your question", especially 1,2,3 and 6.)
NaNg.
|
|
|
|
|
That's simple:
int yearsInCentury = 100;
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Is this in C# or C/C++ like he asked?
:P
|
|
|
|
|
Oops! I didn't notice that. Try this:
int nYearsInCentury = 100;
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
not years in one century, how many days? remember there are years with 365 days and 366.
help
|
|
|
|
|
I am an idiot. I ment how many days is in one century. be causious there are yaers with 365 days and with 366. help. and i could bi written in any C language
|
|
|
|
|
No code but I'll explain the rules (% means modulo):
a) Every 4th year has 366 days (year % 4 == 0)
b) except every 100th year (year % 100 != 0) - only 365 days
c) except every 400th year which is again a leap year (year % 400 == 0)
All together the logical expression for a leap year with 366 instead of 365 days is something like:
bool leapYear = year % 4 == 0 && (year % 100 != 0 || year % 400 == 0)
This should be near enough to the actual code you have to write.
|
|
|
|
|
C#
System.DateTime.DaysInMonth(2004, 2); //returns 29
System.DateTime.DaysInMonth(2005, 2); //returns 28
----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Well there are 80 non-leap years, 19 definite leap years and one depending on whether the century marker is can be divided by 400 or not.
So 29200 days in non-leap years + 6954 in leap years + 365 for the century year + 1 if it is a leap year
= 36519 + 1 if the century marker is a leap year
int daysInCentury = 36519;
if ((centuryYear % 400) == 0)
daysInCentury++;
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
