Re: C# Data link to another PC? [modified] - C# Discussion Boards

Re: issue with Date Format in SSRS

Saksida Bojan21-Dec-09 23:39

Saksida Bojan

21-Dec-09 23:39

i woud use else if because it is small code. I would use Switch for bigger operation

Re: issue with Date Format in SSRS

Blue_Boy21-Dec-09 23:54

Blue_Boy

21-Dec-09 23:54

I prefer switch for small and bigger cases.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

C# Data link to another PC?

miss YY21-Dec-09 22:20

miss YY

21-Dec-09 22:20

SqlConnection thisConnection = new SqlConnection(<br />
				@"Server=(local);Integrated Security=True;" +<br />
			  "Database=northwind");<br />

NOW the server is "local",but when i Install my Program on pc1,install DATABASE on pc2,how can i use date from pc2? i can not change server everytime,i think it can read from a comboBox?how can i do?

Re: C# Data link to another PC?

Calla21-Dec-09 22:30

Calla

21-Dec-09 22:30

You could build the connection string dynamically depending on which server you want to use.
If this answer makes no sense to you, please elaborate your question Smile | :)

Re: C# Data link to another PC?

The Man from U.N.C.L.E.21-Dec-09 22:38

The Man from U.N.C.L.E.

21-Dec-09 22:38

if you use "pc2" instead of "(local)" your app will work what ever machine it is running on. Better to hold the connection string in a config file and provide a means to configure it within your app.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

Re: C# Data link to another PC?

rag_Singh21-Dec-09 22:57

rag_Singh

21-Dec-09 22:57

if you are running program on pc1 and installed database on PC2 then you shoud use connection string as below.
SqlConnection thisConnection = new SqlConnection(
"Server=pc2 IP or pc2 Name;Integrated Security=True;
Database=northwind");

Re: C# Data link to another PC?

Md. Marufuzzaman22-Dec-09 10:36

Md. Marufuzzaman

22-Dec-09 10:36

You can use DataLink to create connection from any workstation to database server...code snippets like

MSDASC.DataLinks ObjDLink;
ObjDLink= new MSDASC.DataLinks();
ObjPrompt = ObjDLink.PromptNew();
strConnectioString = ObjPrompt.ToString();

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Re: C# Data link to another PC? [modified]

hamed-vojdani24-Dec-09 7:13

hamed-vojdani

24-Dec-09 7:13

My offer ,else use MSDASC class

now see what is my offer..

1- Server side:
Run Sql Server browser Service in your database server machine, then
create Valid login for your database,set sql server authentication to Windows and SQL athentication
2- Application side:
with a form like this:
http://privateimage.com/images/9fq89vuk7uokjz8koz.jpg

and with functions like below for buttons

private void btnSearch_Click(object sender, EventArgs e)
{
    SqlDataSourceEnumerator SqlEnumerator = SqlDataSourceEnumerator.Instance;
    DataTable dt = new DataTable();
    dt = SqlEnumerator.GetDataSources();
    dataGridView1.DataSource = dt.DefaultView;
}


private void btnSave_Click(object sender, EventArgs e)
{
    if (dataGridView1.SelectedRows.Count != 0)
    {
        string ConString = "";

        SqlConnectionStringBuilder builder =new SqlConnectionStringBuilder();
        builder.ApplicationName = "MyApp";
        builder.WorkstationID = Environment.MachineName;
        builder.UserID = txtLoginName.Text.Trim();
        builder.Password = txtPassword.Text.Trim());
        builder.InitialCatalog="MyDBName";
        builder.DataSource = dataGridView1.SelectedRows[0].Cells["ServerName"].Value.ToString()+
       "\\"+dataGridView1.SelectedRows[0].Cells["InstanceName"].Value.ToString();

        ConString = builder.ConnectionString;

    }

}

at the end your data link string is ConString variable, you can store it in encrypted file or registry. each time application start check stored connection, and if failed retry this form

note: used namespace are:
using System.Data.Sql;
using System.Data.SqlClient;

hope helps with ugly sample Wink | ;)

modified on Friday, December 25, 2009 9:45 AM

Beginner Question: Data Binding Controls in C# WinForms

Jyncus21-Dec-09 21:50

Jyncus

21-Dec-09 21:50

I'm attempting to create several ComboBox controls on a windows form that are all connected to a relational database.   The controls "narrow" their selection choices when any other given ComboBox is selected to an item.

Similar to say..narrowing down a motherboard model by selecting Intel/AMD --> Socket --> Chipset --> etc.   As I'm quite new to working with data in C#, I was hoping someone could offer a good reference that I can use to read up on this - preferably, a beginner's reference.

Help is appreciated.   =]

SSRS Date format help required

siddisagar21-Dec-09 18:03

siddisagar

21-Dec-09 18:03

Hi Team

I need to show date in this format in my report -----------Dec'09

I am getting format like this Dec2009 for this I am using (MonthName(Month(Parameters!sdate.Value),TRUE)& Year(Parameters!sdate.Value))

Please kindly help me how to get format Dec'09 and also
How to display previous month date also Nov'09 (Need formula)

Re: SSRS Date format help required

Saksida Bojan21-Dec-09 19:29

Saksida Bojan

21-Dec-09 19:29

String date = DateTime.Now.ToString("MMM yy");

However it will return exception if you want " ' " char to be seen.

siddisagar wrote:
How to display previous month date also Nov'09 (Need formula)

String date = DateTime.Now.AddMonths(-1).ToString("MMM yy");

Sqlite + TEXT

Ryan Minor21-Dec-09 11:06

Ryan Minor

21-Dec-09 11:06

I am using Sqlite in an application.

Was wondering if anybody knows limitations on the number of characters one can have when labelling a column as being of type(/affinity) TEXT?

Re: Sqlite + TEXT

S. Brozius21-Dec-09 11:40

S. Brozius

21-Dec-09 11:40

I think you mean how uch data such a column can hold.
As found by using Google : http://www.sqlite.org/limits.html[^]

For your info, the google search (sqlite max text) gave me this hit in a thread referred to on the first result-page...

Nah... What's up, Doc?
CCC's solved : 1
If a bus station is where a bus stops, and a train station is where a train stops, why do I have a work station on my desk?

Scroll bar apperance

viciouskinid21-Dec-09 10:58

viciouskinid

21-Dec-09 10:58

I am writing a c# program that uses property grids. The problem is that for some reason they are displayed in the basic graphics version, the scroll bars are the standard old grey version. The version that you got in windows 95 (i think), or if you turn on the classic theme in windows.

I beleve that the issue is with my current project because when i make a new project, and put a property grid on the form, its scroll bar are displayed correctly, in the current windows theme.

does anyone know how to fix this for my current project?

Re: Scroll bar apperance

Luc Pattyn21-Dec-09 11:27

Luc Pattyn

21-Dec-09 11:27

Hi,

AFAIK you need to call EnableVisualStyles() once to get the modern look of Controls, as in:

[STAThread]
static void Main() {
    Application.EnableVisualStyles();
    Application.SetCompatibleTextRenderingDefault(false);
    Application.Run(new Form1());
}

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Scroll bar apperance

viciouskinid21-Dec-09 11:32

viciouskinid

21-Dec-09 11:32

great thanks!

VB to C# conversion. Implements

aalex67521-Dec-09 5:56

aalex675

21-Dec-09 5:56

I am converting a class from VB to C# so that it can be compiled into the same assembly, but have run into something that I don't know how to handle. The class is a generic ObservableDictionary<tkey, tvalue="">. My problem is that I don't know how to implement both System.Collections.Generic.IEnumerable.GetEnumerator and System.Collections.IEnumerable.GetEnumerator since both of them need an exposed function named GetEnumerator().

The VB code is as follows:

Public Function GetEnumerator() 
  As System.Collections.Generic.IEnumerator(
  Of System.Collections.Generic.KeyValuePair(Of TKey, TValue)) 
  Implements System.Collections.Generic.IEnumerable(
  Of System.Collections.Generic.KeyValuePair(Of TKey, TValue)).GetEnumerator

    Return DirectCast(Dictionary, IDictionary).GetEnumerator()
End Function

Private Function GetEnumerator1() 
  As System.Collections.IEnumerator
  Implements System.Collections.IEnumerable.GetEnumerator

    Return GetEnumerator()
End Function

It looks to me like the VB code is renaming the GetEnumerator function to GetEnumerator1 and explicitly mapping this back to the GetEnumerator function that is being implemented, but I have never seen anything like this in C#.

Is this possible in C#?

Re: VB to C# conversion. Implements

Ian Shlasko21-Dec-09 6:17

Ian Shlasko

21-Dec-09 6:17

Yep. I was going to type it all out, but that's a lot of typing... Heh

VB:

Public Function DoSomething() Implements A.B.C.DoSomething

End Function

C#:

public void A.B.C.DoSomething()
{
}

EDIT: There's a shortcut, by the way... Right-click the interface in the class definition, and pick "Implement Interface Explicitly"

Proud to have finally moved to the A-Ark. Which one are you in?
Author of Guardians of Xen (Sci-Fi/Fantasy novel)

How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

CoderForEver21-Dec-09 5:39

CoderForEver

21-Dec-09 5:39

I was working on conflation .... and I have 25 text boxes .. I collected this strings on an array ... But It becomes a headache for me to compare the 25 strings , and if there are similar strings I want to know how many different strings are there..... the frequency and in which index they are found ... I couldn't have the idea of the algorithm to do that ... Please just show me the algorithm and I will work out the rest my self ...

Thank you

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

Richard MacCutchan21-Dec-09 6:04

Richard MacCutchan

21-Dec-09 6:04

Maybe you should sort them first and then your comparisons will be somewhat easier, as you can find groups without having to do repeated compares.

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

CoderForEver21-Dec-09 6:43

CoderForEver

21-Dec-09 6:43

Depending on what am going to sort them ? .... is it by name .. or by wat?

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

Richard MacCutchan21-Dec-09 6:51

Richard MacCutchan

21-Dec-09 6:51

CoderForEver wrote:
Depending on what am going to sort them ? .... is it by name .. or by wat?

No idea! It's your data so you are the one who has to decide how you want the information ordered. What are your criteria for similarity and difference?

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

CoderForEver21-Dec-09 6:57

CoderForEver

21-Dec-09 6:57

the similarity is just checking z words i.e checking the 25 strings ... if string1 and string 2 are the same then string 2 and 3 and soon

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

Richard MacCutchan21-Dec-09 9:03

Richard MacCutchan

21-Dec-09 9:03

CoderForEver wrote:
the similarity is just checking z words

Then I guess you sort on that ...

Re: How is the algorithm to compare a "lot" of strings, tell z frequency and tell which similar strings are found in which index?

Alan Balkany21-Dec-09 9:55

Alan Balkany

21-Dec-09 9:55

Using a NameValueCollection will do the sorting for you. If the string isn't in the collection, insert it with a count of 1. If it IS there, increment the count.

The collection will instantly tell you how many different strings there are with the Count member.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.