|
On the server, have you enabled named pipes? I have had that same problem before, and It was because I didn't enable named pipes.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
I don't know.
Where should I find the "named pipes"??.
Demian.
"I have always wished that my computer would be as easy to use as my
telephone. My wish has come true. I no longer know how to use my telephone."
-Bjarne Stroustrup, computer science professor, designer of C++
programming language (1950- )
|
|
|
|
|
I don't quite remember, Google it.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
These specify the time, in seconds, to wait for the server to respond before generating an error. The default value is 15 (seconds).
"Connect Timeout=10;"
-or-
"Connection Timeout=10;"
|
|
|
|
|
hello ,
my self ankur , i am very new to .net (C#)
I had made an function in vb .net but same logic is not workin in C#
please help.
I had Written an Following Code .
try
{
da = new SqlDataAdapter(Cmd);
dt = new DataTable();
da.Fill(dt);
int i=0,j=0,p=0,k=0,m=0;
string[] arr = new string[((dt.Columns.Count) * 3)];
if (dt.Rows.Count <= 0) return arr;
for (j = 0; j <= dt.Rows.Count - 1; j++)
{
if ((j == 0))
{
for (i = 0; i <= dt.Columns.Count - 1; i++)
{
arr[i] =dt.Rows[0].ItemArray[i].ToString();
//(dt.Rows[0].Item(i));
p = i;
}
}
if ((j == 1))
{
k = p + 1;
//For k = i To dt.Columns.Count - 1
for (i = 0; i <= dt.Columns.Count - 1; i++)
{
arr[k] =dt.Rows[1].ItemArray[i].ToString();
k = k + 1;
}
}
if ((j == 2))
{
m = k;
//For k = i To dt.Columns.Count - 1
for (i = 0; i <= dt.Columns.Count - 1; i++)
{
arr[m] =dt.Rows[2].ItemArray[i].ToString();
m = m + 1;
}
//Next
}
}
|
|
|
|
|
What do you mean by "not working?"
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
I'm not really sure exactly what you're trying to accomplish here, but I think this code below might suit you better:
<br />
string[] arr = new string[dt.Rows.Count * dt.Columns.Count];<br />
int i = 0;<br />
int j = 0;<br />
foreach (DataRow dr in dt.Rows)<br />
{<br />
j = 0;<br />
foreach (DataColumn dc in dt.Columns)<br />
{<br />
arr[i] = dr.ItemArray[j].ToString();<br />
j++;<br />
i++;<br />
}<br />
}<br />
The results of this would be an array structured as:
[0] = row1 col1
[1] = row1 col2
[2] = row1 col3
[3] = row2 col1
...
Hope that helps, if it doesn't be a little more clear on what you're trying to accomplish and maybe we can come up with something better.
- Arcond
|
|
|
|
|
Hi all,
Is there any function that allows me to get an out put of Monday from a Datetime datataype?
For instance Day(2007/08/13) will return 13.
But i want to get Monday.
How do i get that?
Thanks for your time.
|
|
|
|
|
do ToString() on that and it should give you that, I think.
System.DateTime.Now.DayOfWeek.ToString();
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Thanks very much,
Its not only for today which is (System.DateTime.Now.DayOfWeek).
I wanted to do given a date allways give me the days of that week.
Datetime dt;
dt.dayofweek? can this give me name of the date monday or tuesdda etc....
Thanks
|
|
|
|
|
DateTime.Now just represets the current date as a DateTime object. So you can have your own instance and still use DayOfWeek
|
|
|
|
|
Thanks very much for your help.
Is there any function like that in SQL script?
Thanks
|
|
|
|
|
Look at DATEPART, it's kinda scary though 
|
|
|
|
|
You bet. Yes it can, you can do something like this:
DateTime DateT = new DateTime(1, 3, 3);<br />
MessageBox.Show(DateT.Day.ToString());
And that will display the Day of the week of any date you specify
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Thanks,
I have a datetime column on my table( ADEDATE type datetime)
Select id, ADEDATE from Table ,I would like to get the day of the week for the result of the selecet statement.
the result of the select statement will be similar to ..
12,Monday
13,sunday
14,saturday
Which function shall i use for this task?
Thanks
|
|
|
|
|
Well, you should parse the Year, Month, and Date from the field, drop them into variables and then drop them into your DateTime object, and then return the Day of the week. Does this answer your question?
DateTime DateT = new DateTime(Year, Month, Date);
MessageBox.Show(DateT.Day.ToString());
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Thanks very much,
Well i have to use stored procudure in Sql script.All i want is how my select statement can get the days of the week for my Datecoulmn on my table?
May be i should post it Sql forum?
Did you get me now?
Thanks
|
|
|
|
|
Oh yes, I get you now. You are trying to do all this in a stored procedure. Yeah, you should ask in the SQL forum.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Use one of the many formatting options available in the DateTime object.
MessageBox.Show(DateTime.Now.ToString("d"));
MessageBox.Show(DateTime.Now.ToString("dd"));
MessageBox.Show(DateTime.Now.ToString("ddd"));
MessageBox.Show(DateTime.Now.ToString("dddd"));
|
|
|
|
|
Hello!
Little problem. I want to get non-english chars from e-mail, but can't! For example:
From: "=?KOI8-R?B?49fJIOfJ0ts=?=" must resolve as From: "Цви Гирш"
Thanks!
|
|
|
|
|
hi
it's a mime encoded line:
=?KOI8-R?B?49fJIOfJ0ts=?= means:
KOI8-R is the ascii encoding
B is the encoding method
B = Base64
Q = Quoted printable
and 49fJIOfJ0ts= is the content
to get Цви Гирш from "=?KOI8-R?B?49fJIOfJ0ts=?=" you do the following:
string s = "=?KOI8-R?B?49fJIOfJ0ts=?=";
string[] frg = s.Substring(2,s.Length-4).Split('?');
if (frg.Length == 3)
{
string encoding = frg[0];
string method = frg[1];
string content = frg[2];
switch (method.ToUpper())
{
case "B":
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding(encoding);
byte[] val = Convert.FromBase64String(content);
string text = enc.GetString(val);
System.Windows.Forms.MessageBox.Show(text);
break;
}
case "Q":
{
break;
}
}
}
hope this helps
M@u
|
|
|
|
|
cool.. u got 5 from me..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
Thanks!!!!!!!!!!!!!!!!!!!!!
thank you so much!!!
|
|
|
|
|
Hi All
I am using PropertyGrid to show the properties of object..
want to use property grid with combo box and taking help from this MSDN link..
http://msdn2.microsoft.com/en-us/library/aa302326.aspx
here is the code that I am using..
<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using System.ComponentModel;<br />
<br />
namespace PropertyGridTest<br />
{<br />
[DefaultPropertyAttribute("Person")]<br />
class Person : StringConverter<br />
{<br />
public Person(string inName, string inAddress, int inAge, bool inEmployed)<br />
{<br />
name = inName ;<br />
address = inAddress ;<br />
age = inAge ;<br />
employed = inEmployed;<br />
}<br />
<br />
<br />
public Person(string inName)<br />
{<br />
name = inName;<br />
}<br />
<br />
<br />
private string name;<br />
private string address;<br />
private int age;<br />
private bool employed;<br />
<br />
<br />
public override bool CanConvertTo(ITypeDescriptorContext context, Type destinationType)<br />
{<br />
return true;<br />
}<br />
public override bool GetStandardValuesSupported(ITypeDescriptorContext context)<br />
{<br />
return true;<br />
}<br />
<br />
public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)<br />
{<br />
return new StandardValuesCollection(new string [] {"AAA", "BBB", "CCC", "DDD" });<br />
<br />
}<br />
<br />
public override bool GetStandardValuesExclusive(ITypeDescriptorContext context)<br />
{<br />
return false;<br />
}<br />
<br />
<br />
<br />
[TypeConverter(typeof(Person)), <br />
CategoryAttribute("Person Details"), DescriptionAttribute("Name of the Person")]<br />
public string Name<br />
{<br />
get<br />
{<br />
return name;<br />
}<br />
set<br />
{<br />
name = value;<br />
}<br />
}<br />
<br />
[CategoryAttribute("Person Details"), DescriptionAttribute("Address of the Person")]<br />
public string Address<br />
{<br />
get<br />
{<br />
return address;<br />
}<br />
set<br />
{<br />
address = value;<br />
}<br />
}<br />
<br />
[CategoryAttribute("Person Details"), DescriptionAttribute("Employed")]<br />
public bool IsEmployed<br />
{<br />
get<br />
{<br />
return employed;<br />
}<br />
set<br />
{<br />
employed = value;<br />
}<br />
}<br />
<br />
<br />
[CategoryAttribute("Person Details"),<br />
DescriptionAttribute("Age of the Person")]<br />
public int Age<br />
{<br />
get<br />
{<br />
return age;<br />
}<br />
set<br />
{<br />
age = value;<br />
}<br />
}<br />
}<br />
}<br />
<br />
<br />
and
<br />
<br />
private void radioButton1_CheckedChanged(object sender, EventArgs e)<br />
{<br />
if (radioButton1.Checked)<br />
{<br />
try<br />
{<br />
Person person = new Person("John", "CA", 5, false);<br />
propertyGrid1.SelectedObject = person;<br />
}<br />
catch (Exception ex)<br />
{<br />
MessageBox.Show(ex.Message);<br />
}<br />
}<br />
<br />
Now when i run the application then a exception is caught and the message is "Constructor on type PropertyGridTest.Person not found" is popped up,
also "Name" property is disabled.
Please help me to solve this problem..
that is how to show combobox in propertyGrid.
Please help me.
Thanks & Regards
|
|
|
|
|
rajeevktripathi wrote: Person : StringConverter
Your class should not derive from a TypeConverter, rather use the TypeConverter attribute to decorate the 'Person' class.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
