Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not all code returns a value
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Not all code returns a value
Environment versions
Environment:
C# 1.1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01033698
Message ID:
01033698
Views:
73
I keep recieving an error telling me not all code paths return a value, though I'm pretty sure I have it covered? I just cant see what I'm missing here, I think I have everything returning a value.

private string sqlreturn(string cmd,string search_item)
{
//this method returns a value for the item thats passed
SqlConnection con1 =new SqlConnection(connection);
SqlCommand cmd1 = new SqlCommand(cmd,con1);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add(new SqlParameter("@search_item", SqlDbType.VarChar));
cmd1.Parameters["@search_item"].Value = search_item;
SqlDataAdapter searchs = new SqlDataAdapter(cmd1);
con1.Open();
DataSet search = new DataSet("search");
searchs.Fill(search, "search");
con1.Close();
DataView dv = new DataView(search.Tables[0]);
if (cmd.Trim().Equals("sp_PMreturn_item"))
{
foreach (DataRowView drv in dv)
{
return drv["itmdesc"].ToString().Trim();
}
}
else
{
return "";
}
}
Next
Reply
Map
View

Click here to load this message in the networking platform