TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
rachayita jaiswal
NA
217
106.5k
IN operator is not working with query in VB.Net
Jul 23 2013 6:23 AM
Hi, this is my stored procedure -
-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
drop procedure if exists SP_Login;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_Login`(_action varchar(10),
_uname varchar(500)
)
BEGIN
if _action = 'SelectU' then
SELECT Name as CompanyName, Uname as UserName, Pwd,
Mobile as MobileNumber, limax as NumberofVehicles, Address,
RID as UserId, parent_user, child_user, ProfileRights, AllocationRights,
GeneralRights from Regis
WHERE UName IN (_uname) ;
end if;
END
and this is my VB.Net code -
dtUserDetails = DBClass.GetDataTableForLogin("SelectU", Children, "")
grdUserProfile.DataSource = dtUserDetails
Public Function GetDataTableForLogin(ByVal action As String, ByVal uname As String) As DataTable
Dim dtdatatable As New DataTable
Dim conn As OdbcConnection = New OdbcConnection(ConfigurationManager.ConnectionStrings("DBConnection").ToString)
Dim cmd As OdbcCommand = conn.CreateCommand
cmd.CommandText = "{call SP_Login(?,?)}"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("_action", action)
cmd.Parameters.AddWithValue("_uname", uname)
)
conn.Open()
Dim da As New OdbcDataAdapter(cmd)
da.Fill(dtdatatable)
da.Dispose()
conn.Close()
Return dtdatatable
when i am running my code uname value i am getting,but after that in datatable it is coming blank.
tell me is there any problem with my code?
Reply
Answers (
4
)
Dynamically change orientation for particaular page in word?
Access Resources from published application