Click here to Skip to main content
15,850,607 members
Home / Discussions / Database
   

Database

 
QuestionVB.NET MYSQL sum row values Pin
KipkoechE15-Feb-15 21:51
KipkoechE15-Feb-15 21:51 
AnswerRe: VB.NET MYSQL sum row values Pin
Richard MacCutchan15-Feb-15 23:11
mveRichard MacCutchan15-Feb-15 23:11 
QuestionMYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 5:19
KipkoechE15-Feb-15 5:19 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Afzaal Ahmad Zeeshan15-Feb-15 5:41
professionalAfzaal Ahmad Zeeshan15-Feb-15 5:41 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 5:46
KipkoechE15-Feb-15 5:46 
GeneralRe: MYSQL TABLE RECORDS TO ARRAY Pin
KipkoechE15-Feb-15 7:15
KipkoechE15-Feb-15 7:15 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
Eddy Vluggen15-Feb-15 9:18
professionalEddy Vluggen15-Feb-15 9:18 
AnswerRe: MYSQL TABLE RECORDS TO ARRAY Pin
sanket16415-Feb-15 18:43
sanket16415-Feb-15 18: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 14:39
indian14313-Feb-15 14:39 
QuestionEdit SSRS report file Pin
indian14312-Feb-15 15:08
indian14312-Feb-15 15:08 
AnswerRe: Edit SSRS report file Pin
Member 1102161912-Feb-15 20:07
Member 1102161912-Feb-15 20:07 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 1:25
Chris Quinn13-Feb-15 1:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 14:36
indian14313-Feb-15 14:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 3:28
KipkoechE12-Feb-15 3:28 
AnswerRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:26
mveRichard Deeming12-Feb-15 4:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:06
KipkoechE12-Feb-15 5:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:20
professionalGuyThiebaut12-Feb-15 5:20 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:27
KipkoechE12-Feb-15 5:27 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:33
professionalGuyThiebaut12-Feb-15 5:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 5:34
mveRichard Deeming12-Feb-15 5:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:53
KipkoechE12-Feb-15 5:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:03
KipkoechE12-Feb-15 6:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:18
professionalGuyThiebaut12-Feb-15 6:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:23
KipkoechE12-Feb-15 6:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:28
professionalGuyThiebaut12-Feb-15 6: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.