How to cut the length of a field (requires that the cut length be determined by passing parameters)

prince_zxb

How to extract the specific value of a field in a database table by passing parameters in one method.

My SQL statement is always wrong, I ask you experts, can you give me a code example, or give me a different solution. Attached code examples are best! !!

Thank you, I am a novice rush. A program can't do it for a long time.

shenmue024

string sLenght = Request.QueryString ["Length"];
if (sLenght == null) return;

if (! this.IsInt (sLenght)) return;
int iLength = Convert.ToInt32 (sLenght);
string sValue = "DSFSFDSFSDFFFD"; // taken from the database
if (sValue.Length> iLength)
{
sValue = sValue.Substring (0, iLength);
}

Response.Write (sValue);
Ranch



bool IsInt (object o)
{
try
{
Convert.ToInt32 (o);
return true;
}
catch
{
return false;
}

}

lisongfox

public class classDB
 {
    public classDB ()
    {
    }
   public static SqlConnection createConnection ()
    {
     System.Data.SqlClient.SqlConnection conn = new SqlConnection ("server = .; database = pubs; uid = sa; pwd =;");
     return conn;
    }
 }


public string GetValue (string sPara)
{
SqlConnection cn = new SqlConnection ();
 string strSQL = "SELECT * FROM table where primary key = '" + sPara + "'";

DataSet ds = new DataSet ();

SqlCommand cmd = new SqlCommand (strSQL, cn);
cn.Open ();
    SqlDataAdapter da = new SqlDataAdapter ();

    da.SelectCommand = cmd;


sqlDataAdapter1.Fill (ds);

sqlConnection.Close ();

// Close the data connection
if (ds.Tables [0] .Rows.Count> 0)
{
return ds.Tables [0] .Rows [0] [0] .ToString ();
}
else
{
return "";
}
}

vidato

Don't know if these are useful?
protected string CutString (string str, int length)
{
string newString = "";
if (str! = "")
{
if (str.Length> length)
{
newString = str.Substring (0, length) + "...";
}
else
{
newString = str;
}
}
return newString;
}

Calling method:
string str = "Truncate the specified length of the string as needed";
str = CutString (str, 10);
If you are in asp.net and want to use it in data list controls (such as: DataGrid, DataList, Repeater, etc.) to achieve the effect similar to the news list described above, you can write:
<% # CutString (DataBinder.Eval (Container.DataItem, "NewTitle"). ToString (), 16)%>

prince_zxb

Thank you very much for giving you these multiple codes, I have read them, thank you!