Click here to Skip to main content
15,440,014 members
Home / Discussions / Database
   

Database

 
QuestionVB.NET MYSQL sum row values Pin
KipkoechE15-Feb-15 20:51
MemberKipkoechE15-Feb-15 20:51 
AnswerRe: VB.NET MYSQL sum row values Pin
Richard MacCutchan15-Feb-15 22:11
mveRichard MacCutchan15-Feb-15 22:11 
QuestionMYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 4:19
MemberKipkoechE15-Feb-15 4:19 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Afzaal Ahmad Zeeshan15-Feb-15 4:41
mveAfzaal Ahmad Zeeshan15-Feb-15 4:41 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 4:46
MemberKipkoechE15-Feb-15 4:46 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 6:15
MemberKipkoechE15-Feb-15 6:15 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Eddy Vluggen15-Feb-15 8:18
professionalEddy Vluggen15-Feb-15 8:18 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
sanket16415-Feb-15 17:43
Membersanket16415-Feb-15 17:43 
C#
public void GetDatainArr()
{
        string strSQl = "";
        string[] Arr = new string[50];
        strSQl = "select [Id] from [tblname] ";
        DataTable dt = GetDataTable(strSQl); //GetDataTable function 
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Arr[i] = Convert.ToString(dt.Rows[i][0]);
            }
        }
}
public DataTable GetDataTable(string Sql)
{
        SqlConnection conn = new SqlConnection("ConnectionString ");
        conn.Open();
        DataTable dt = new DataTable();
        SqlCommand cmd = new SqlCommand(Sql, conn);
        SqlDataAdapter ad = new SqlDataAdapter();
        ad.Fill(dt);
        conn.Close();
        return dt;
}



This code in C# so you can Convert this code in vb using this link http://www.developerfusion.com/tools/convert/csharp-to-vb/
Sanket Gandhi

QuestionSSRS report is not fitting withing Margins Pin
indian14313-Feb-15 13:39
Memberindian14313-Feb-15 13:39 
QuestionEdit SSRS report file Pin
indian14312-Feb-15 14:08
Memberindian14312-Feb-15 14:08 
AnswerRe: Edit SSRS report file Pin
Member 1102161912-Feb-15 19:07
MemberMember 1102161912-Feb-15 19:07 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 0:25
MemberChris Quinn13-Feb-15 0:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 13:36
Memberindian14313-Feb-15 13:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 2:28
MemberKipkoechE12-Feb-15 2:28 
AnswerRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 3:26
mveRichard Deeming12-Feb-15 3:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:06
MemberKipkoechE12-Feb-15 4:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:20
professionalGuyThiebaut12-Feb-15 4:20 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:27
MemberKipkoechE12-Feb-15 4:27 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:33
professionalGuyThiebaut12-Feb-15 4:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:34
mveRichard Deeming12-Feb-15 4:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:53
MemberKipkoechE12-Feb-15 4:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:03
MemberKipkoechE12-Feb-15 5:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:18
professionalGuyThiebaut12-Feb-15 5:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:23
MemberKipkoechE12-Feb-15 5:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:28
professionalGuyThiebaut12-Feb-15 5:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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