Friday, June 28, 2019



date functiosn
var test = "test";

  type: "POST",
  url: "project/function",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  data: { input: test },
  success: function (response) {
  failure: function (response) {

public void function(string input)
Read More »

Monday, April 1, 2019

asp net mvc tutorial step by step for beginners with examples mvc tutorials MVC tutorials sponsored by all tech geeks. this tutorial provides all articles in one container. it helps you like the index of the book. what is MVC ?. it is an architectural design pattern and stands for Model View and Controller. this container covers all topics of the MVC. it helps from freshers level to professional level. if you are starting level then you need basic knowledge of C#, Advanced OOPs, Visual Studio, and HTML.
it is an open source web development framework by Microsoft. it is alternate to and not the replacement of

                                               Asp.Net MVC  - Get Started

  1. MVC Tutorials- Get Started 
  2. Architecture
  3. First Application
  4. Folder Structure
  5. Controller
  7. Model
  8. Bundling
  9. View Bag
  10. Temp Data
  11. View Data
  12. Action Methods
  13. Action Selectors
  14. HTML Helpers
  15. Partial Views
  16. Layout View
  17. Filters
  18. Action Filters
  19. Validations
  20. Area
  21. What is Entity Framework and types  
  22. Creating Project in Database First Approach
  23. Creating Project in Code first approach
  24. Creating Project in Model Base First approach

Read More »

Tuesday, March 26, 2019

Sending Emails from Google Spreadsheet

google sheets are more popular nowadays. day by day the use of Apps script is increasing.
we can write the javascript to do anything like a NetSuite.Netsuite is a cloud ERP. it has only javascript development. same as google apps script also will use for all Google products (Apps) in the cloud.
google compute is the best IAAS cloud in the IT industry.

The main points in this article are to "send emails from google sheet". its very simple. and single step to do the above task.
Step 1: Login into Gmail.
Step 2: Go to google drive
Step 3: select the new button and select the spreadsheet
Step 4: type Email and name columns in the spreadsheet.
Step 5: go to tools and select the Script editor
Step 6: write the below script use where ever you want it

                                 MailApp.sendMail(to, subject, body) ;

Sending Emails from Google Spreadsheet

in the above image, you can find the function. the function name is myFunction(){}.

         MailApp.sendMail("","Hello test mail","Hello from All Tech Geeks");

But we need to pick email from the spreadsheet and send the mail from the sheet.

function Send Email() {

                  var sheet =SpreadsheetApp.getActiveSheet();
                  var r   = sheet.getRange("A1:B2");
                   var  customerdata=range.getValues();
for(j in customerdata)
           var row=customerdata[i];
           var Email =row[0];
           MailApp.sendMail(row[1],"Email id is"+Email+,"this is test email");

how to get data from the browser to the spreadsheet or how to use the google sheet as a database.
if we get the data from the website or anywhere. then we can do anything with that data.

Read More »

Wednesday, March 20, 2019

bind Dropdown list in

 public void bindcus()
        ddlcustomer.Items.Add(new ListItem("--SELECT--","0"));
        ddlcustomer.AppendDataBoundItems = true;
        dao.type = "CUSTOMER";
        DataTable dt= new DataTable();
        dt =;
        if (dt.Rows.Count > 0)
            ddlcustomer.DataSource = dt;
            ddlcustomer.DataTextField = "name";
            ddlcustomer.DataValueField = "code";

Read More »

Using Google spreadsheets as Database For Blog

What is “Google spreadsheets as database”. nowadays every one using the website if they want a website then needs to buy the space for the website and for storing purpose need to buy the space so in both cases we need to buy the spaces from third parties like GoDaddy, Bluehost etc. So to avoid these type of problems you need to know some knowledge in “google apps script”.

Everyone has a Gmail account. Drive also free. Google drive has so many free applications like Docs, sheet, slides, forms, apps script, Jamboards, blog etc. By using these applications we can do amazing things without a database like My SQL, SQL Server, DB2 etc.

Here I will teach you how to use Google spreadsheets as a database for your web application. But I am not using web application. Instead of that, I am going to use google blog.

Step 1: Open Gmail account
Step 2: create a blog after login into your Gmail account and name it.
Step 3: go to google drive click on the new button and create a new google spreadsheet.
Step 4: Give the name for google spreadsheets
Step 5: Go to blog create a new blog account
Step 6: create a page insert_values.
Step 7: publish the blog test it you will surprise.

google spreadsheets as database for your blog

Now open Google spreadsheets and name it as "insert values"  and given 5 column names as shown below image
 Time_stamp, Id, Name, State, City, Country.

google spreadsheet as database 
Now click on tools click on script editor. In script editor you can write the code in javascript

google spreadsheet as database

The name is as insert values  and the extension is “.gs” means google script it is nothing but javascript.
In the editor, you can write the script.

google spreadsheet as database

Next, go to google spreadsheets and copy the link and paste in as shown below image.
It is a “SpreadsheetApp.openByUrl”. it means while running the program it opens the URL works as per requirement.

google sheet as database for blog

Finally, publish the script for anyone and save the script_url. It will consume it anywhere.
Click Deploy à deploy as Web app à select “who has access to the app as anyone”.
Save the script URL.
google sheet as database for your website

Select the Anyone as shown above image and Click on deploy button.
After the click, it asks to need permission to click on it. Select your Gmail account and go to advance click on insert value(unsafe).  Finally, click on allow button copy the URL.
below is the script.
Now goto blog. Create a new blog  and create a new page in the blog
google sheets api

Now go to notepad++ write javascript and paste the URL as shown below.
And create the required fields in the body tag
google sheets api

 Finally, copy all the above script  and paste in blogger page publish it
Open in the browser then it looks like below image. these all values will insert into google spreadsheets after the button click
google sheets api for your website

Click on insert button then the data goes and sits in insert_values google spreadsheets as shown below image. After insert button, it shows as successfully inserted.
google sheets api for your website

Now go and check the google spreadsheets. All value you can find in google spreadsheets.
google sheets api for your website

the above article only for insert values into google spreadsheets. in next article, you can find the Update, delete and view the values from "google spreadsheets as database"

Read More »