I got two tables called Genre and Albums.
I want to access data (all the albums) inside each Genre how can i do it.
Do i have to make viewModel for this or some thing else and what sort of query can i use.
Thanks in advance
View Complete Post
hello, I have a search option which a person can use a multi select listbox. I have it coded so it would loop through to see if its selected or not. I also have a stored procedure where the sql statement is coded for the select statement. For some reason, its not populating my gridview. Where am I doing wrong? Below is the code and stored procedure. Thank you, Carlos
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ExportContacts2.aspx.vb" Inherits="ExportContacts2" %>
<%@ Import Namespace="System.Web.Mail" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Protected Sub submit_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim strtxtevents1 As String
Dim lin4 As ListItem
Dim myArrayList4 As ArrayList = New ArrayList()
Dim strarr4() As String
For Each lin4 In eventsi.Items
If lin4.Selected = True Then
Can someone tell me how to create a progressBar to show the data retrieving progress.
I'm looking for some advise on how I could solve the problem I face, I have various instances of sqlexpress 2005 in different remote locations which are not accessible via internet vpn etc as they are all in corporate networks that will not allow access.
What I think I need to do is create some sort of process/service that can be installed on the client and run at a set time/date that collects all the data from theses instances and then push the changes to our remote instance of sql server. Can anyone possibly
point me in the right direction of various technologies I should be looking into to solve this problem. All clients would be running windows XP. I have been searching for a few day's but I can't find anything to get me going. If this is not the right forum
for this type of question can you suggest any?
I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.
I need to:
1. Check that the relevant data has been added into the database then
2. Email the details of the relevant data when completed.
Thanks in advance for your help,
I have used the above method to configure my crystal report ...
Its working fine , But i have huge number of data in database ....
So , it take long time to load the report ...
So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.
Plz help me with this issue ...
Also , Plz explain me abt index legend in crystal report.
Hi dear coders
though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.
i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net
i will be highly thankful for any kind help from you geniuses.
I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where
i can just call the method with my SQL Query
Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");
Plz Post the link if there is any open source !
Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.
MSDN Magazine July 2010
This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.
MSDN Magazine August 2009
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.
Brian A. Randell
MSDN Magazine February 2007
Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.
MSDN Magazine September 2004
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
Can someone point me in the right direction on how to submit data from a jQuery form to a ASMX webservice? I have gotten everything on the form ready to be submitted to the database and now I am stuck on how to send it over using $.ajax(). Everything I have read tells me how to get data from a webservice and display it with jQuery, but not the other direction nor how to access the json data within the within the webservice service(similar to a Request.Form approach with ASP.NET forms).
In other words:
1. What do I need to do to my webservice to make sure it can receive data from the jQuery form.
2. What do I need to do in jQuery to receive an acknowledgement the save on the server side was successful.
I can explain more if need be, but if there is a comprehensive tutorial on not only reading, but also WRITING data with jQuery, JSON, etc. I would love to get pointed in that direction.
I want to use gridview and bind the data and after i want insert the data in database using jquery,
below the link i got for delete
but i want the sample example for insert row from gridivew and add the database.