Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
G

Gaurav Dudeja India

@Gaurav Dudeja India
About
Posts
102
Topics
5
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • web application
    G Gaurav Dudeja India

    you can also use javascript validation controls for it

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET

  • display Analog clock
    G Gaurav Dudeja India

    You can also use java script analog control from dynamicdrive.com

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp asp-net

  • dont really know the title..
    G Gaurav Dudeja India

    you can scrap the data from that site and show it on your site.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET question

  • clearing a asp:listbox takes too much of time
    G Gaurav Dudeja India

    Please try to use javascript , it will take less time.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET

  • selecting data from excel sheet
    G Gaurav Dudeja India

    sorry i never do this so no idea.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET css question

  • selecting data from excel sheet
    G Gaurav Dudeja India

    Use this function

    public static DataTable getDataTable(string strFilename)
    {
    string SQL = "select * from [Sheet1$]";
    string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFilename + ";";
    connectionString += @"Extended Properties=""Excel 12.0;HDR=YES;""";
    OleDbConnection conn = new OleDbConnection(connectionString);
    OleDbCommand cmd = new OleDbCommand(SQL, conn);
    DataTable dt = new DataTable();
    OleDbDataAdapter da = new OleDbDataAdapter(cmd);
    da.Fill(dt);
    da.Dispose();
    conn.Dispose();
    cmd.Dispose();
    return dt;
    }

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET css question

  • Graphs in C# - Windows application
    G Gaurav Dudeja India

    you can use microsoft chart control for graphs in dotnet applications

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    C# csharp question

  • How to upload Excel file to Database from ASP.NET
    G Gaurav Dudeja India

    use this function

    public static DataTable GetDataTableFromExcel(string SourceFilePath)
    {
    string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
    "Data Source=" + SourceFilePath + ";" +
    "Extended Properties=Excel 8.0;";

    using (OleDbConnection cn = new OleDbConnection(ConnectionString))
    {
        cn.Open();
    
        DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        if (dbSchema == null || dbSchema.Rows.Count < 1)
        {
                throw new Exception("Error: Could not determine the name of the first worksheet.");
        }
    
        string WorkSheetName = dbSchema.Rows\[0\]\["TABLE\_NAME"\].ToString();
    
        OleDbDataAdapter da = new OleDbDataAdapter("SELECT \* FROM \[" + WorkSheetName + "\]", cn);
        DataTable dt = new DataTable(WorkSheetName);
    
        da.Fill(dt);
    
        return dt;
    }
    

    }

    This will return you datatable after that with the help of loop insert it into database

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp database asp-net sql-server sysadmin

  • How we read dll in asp.net +C#
    G Gaurav Dudeja India

    Please clear what you want to ask...

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp asp-net

  • Final Year Project
    G Gaurav Dudeja India

    You have to search Codeproject Article, here are many articles from them you can inspired for your final year project.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp asp-net database sql-server sysadmin

  • dropdownlist fill problem
    G Gaurav Dudeja India

    put the databinding in !ispostback i.e. if(!ispostback) { ddl.bind(); }

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET database help question

  • execution of a C # application
    G Gaurav Dudeja India

    what do you want to ask, please explain in detail.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    C# question

  • Add In bcc mail program in outlook.
    G Gaurav Dudeja India

    first take some search from google and if you face any problem then only ask here, thanks

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp visual-studio tutorial

  • checkbox checked event not working
    G Gaurav Dudeja India

    Use this

    int checkedCount = 0;
    foreach (GridViewRow row in gvData.Rows)
    {
    bool result = ((CheckBox)row.FindControl("CheckBox1")).Checked;
    if (result)
    {
    return true;
    }
    else
    {
    return false;
    }
    }

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET css

  • sql query problem
    G Gaurav Dudeja India

    there is one space in end of this '529042010\All Data 4cr\0.66cr_calicut_1401 ' remove space i.e. you use '529042010\All Data 4cr\0.66cr_calicut_1401'

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET database csharp sql-server sysadmin help

  • Click-in and Click out functionality
    G Gaurav Dudeja India

    yes you have to do as same as sandeep said.

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET question

  • Click-in and Click out functionality
    G Gaurav Dudeja India

    Please explain in detail what adjactly you mean by click in and click out? and what do you want

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET question

  • Is it Possible to download a pdf file from a web page without showing the URL of pdf file in address bar
    G Gaurav Dudeja India

    you can zip that pdf then user download it wirhout opening in another browser

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    C#

  • How to import gmail,yahoo, etc. contacts in asp.net
    G Gaurav Dudeja India

    ohh :) sorry Abhijit....

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp asp-net tutorial

  • How to import gmail,yahoo, etc. contacts in asp.net
    G Gaurav Dudeja India

    Each of them have their own services to import contacts,please see on google.com

    Gaurav Dudeja http://www.gdinfotechindia.com
    Dont be afraid of changing your life to better !

    ASP.NET csharp asp-net tutorial
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups